Tips and Tricks (SQL)

A few tips and tricks for SQL Server - via bersileus@SQLJunkies - Tips & Tricks.

  • Rounding by halves
  • Comma seperated list in WHERE clause
  • Simple paging
  • Case-sensitive comparison
  • Call stored procedure on other server

Comments

Popular posts from this blog

Link: HTML Agility Pack (.NET)

Basic Excel Spreadsheet Generation (ASP/ASP.NET)

ASP.NET: Binding alphabet to dropdown list