是用newID()方法即可产生
//转换为字符串
SELECT CONVERT(char(266),@myid) AS 'char';
//转为为numeric
--SELECT CONVERT(numeric(19,0),BINARY_CHECKSUM(NEWID())) AS 'numeric';
--GO
//row_number
select row_number()over(order by @@spid),* from cp
是用newID()方法即可产生
//转换为字符串
SELECT CONVERT(char(266),@myid) AS 'char';
//转为为numeric
--SELECT CONVERT(numeric(19,0),BINARY_CHECKSUM(NEWID())) AS 'numeric';
--GO
//row_number
select row_number()over(order by @@spid),* from cp