June 13, 2009

Sql Server - Generate Auto number in Select Query

SELECT ROW_NUMBER() OVER (ORDER BY ColumnName ASC) AS ROWID, * FROM Tablename
Posted by
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)