Showing posts with label serial. Show all posts
Showing posts with label serial. Show all posts

Friday, March 30, 2012

rownum equivalent ?

Hi,
Rownum returns the serial number for the records in Oracle.
Id there an equivalent for the same in SQL Server ?
select rownum from test_table;
Please advise,
Thanks
Samsqlserver has none, the clostest match is to add an identifier-column.