SQL语句如下:
SELECT Row_Number() over ( order by getdate() ) as '序号', * FROM T_Cod_XQ
其中序号就是查询需要的自增列,如 1,2,3,4,5,6,7......
SQL语句如下:
SELECT Row_Number() over ( order by getdate() ) as '序号', * FROM T_Cod_XQ
其中序号就是查询需要的自增列,如 1,2,3,4,5,6,7......