--获取当前时间
SELECT GETDATE();
2021-05-13 10:47:29
--获取GUID
SELECT NEWID();
EBA6A9B8-4C99-435A-B807-837BD89AA679
--获取行号,类似ORACLE的rownum
SELECT row_number() over (order by id) FROM XXXTable;
--获取当前时间
SELECT GETDATE();
2021-05-13 10:47:29
--获取GUID
SELECT NEWID();
EBA6A9B8-4C99-435A-B807-837BD89AA679
--获取行号,类似ORACLE的rownum
SELECT row_number() over (order by id) FROM XXXTable;