Venkatmca008
Senior Software Engineer
Friday, February 25, 2011
Create temp table with identity instant select statement
SELECT SequentialRowNumber = identity(INT,1,1),ROW_NUMBER()
OVER (ORDER BY CustID) AS Row,* into mytit1 from #customers
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
No comments :
Post a Comment