Skip to content

Instantly share code, notes, and snippets.

@togakangaroo

togakangaroo/Generate List off Numbers.sql

Created June 28, 2013 16:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save togakangaroo/5885847 to your computer and use it in GitHub Desktop.
Save togakangaroo/5885847 to your computer and use it in GitHub Desktop.
Download ZIP
Generate a list of numbers in sql server. Cause I aalways forget how to do this.
Raw
Generate List off Numbers.sql
SELECT TOP 10 ROW_NUMBER() OVER (order by id) FROM sysobjects
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment