This method will only work when you do "select into
Syntax is :
select identity(int,1,1) as RowNumber, *
into newtable
from oldtable
Showing posts with label sequence number. Show all posts
Showing posts with label sequence number. Show all posts
Wednesday, April 10, 2013
Generate Row number
This method will only work when you do "select into
Syntax is :
select identity(int,1,1) as RowNumber, *
into newtable
from oldtable
Subscribe to:
Posts (Atom)