Revision: 31663
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at September 10, 2010 05:35 by g8rpal
Initial Code
;WITH Tens AS
(
SELECT 1 N UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1
)
SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 0)) RN FROM Tens
Initial URL
http://www.sqlservercentral.com/Forums/Topic980975-338-1.aspx
Initial Description
Initial Title
Autogenerate identity column via Select
Initial Tags
function
Initial Language
SQL