differentpla.net

Because whenever I've been away from SQL Server for more than a couple of weeks, I forget.

Let's assume that you've got a table:

CREATE TABLE #t (
  Id INT IDENTITY,
  Name VARCHAR(50),
  Number INT )