一个sql的问题,怎么在查询中增加一个自增列(给出结果立刻结帖)
jetdw 2007-08-06 10:12:43 比如查询语句select stor_id,stor_name,stor_address from pubs..stores的结果中为
stor_id stor_name stor_address
6380 Eric the Read Books 788 Catamaugus Ave.
7066 Barnum's 567 Pasadena Ave.
7067 News & Brews 577 First St.
7131 Doc-U-Mat: Quality Laundry and Books 24-A Avogadro Way
7896 Fricative Bookshop 89 Madison St.
8042 Bookbeat 679 Carson St.
我想在结果中增加一列,形式为:
id stor_id stor_name stor_address
1 6380 Eric the Read Books 788 Catamaugus Ave.
2 7066 Barnum's 567 Pasadena Ave.
3 7067 News & Brews 577 First St.
4 7131 Doc-U-Mat: Quality Laundry and Books 24-A Avogadro Way
5 7896 Fricative Bookshop 89 Madison St.
6 8042 Bookbeat 679 Carson St.
请大家帮下忙,环境是mssql2000