På svenska |    
  • EPiServer
  • ASP.NET
  • Programming
  • Search
  • Life
  • About
  1. You are here: 
  2. Home/
  3. Programming/
  4. SQL Server

SQL Server

Latest articles and notes about SQL Server

  • Programming SQL Server June 26, 2009

    My favorite way to do paging with T-SQL

    This is how I like to do paging with T-SQL. I've seen quite alot of ways to do paging with SQL Server, both with and without temporary tables and this is definetly my favorite as I find it both straight forward and easy to read.

  • Programming SQL Server June 26, 2009

    Getting the first day in a week with T-SQL

    A colleague just asked me if I knew a way to get the first day in a week in SQL Server. While I'm sure that there are many ways to get the first day (date) in a week here is a very simple way that in my opinion is quite elegant.

  • Programming SQL Server October 27, 2008

    Dynamic sorting with T-SQL

    Almost all stored procedures that I write whose job it is to fetch data has to sort the data according to one or several columns. More often than not the selection of those columns, and the sort direction, is determined by the web application and therefore has to be based on parameters.

  • EPiServer
  • ASP.NET
  • Programming
  • Search
  • Life
  • About
  • Archive and search