1、自增长
studentnointprimarykeyidentity(1,1)——bigint也是可以的
2、创建uuid
customeriduniqueidentifierprimarykeydefaultnewid()
获取UUID:
selectnewid()即可
1.获取32位的UUID -----批处理
declare@newidvarchar(36)=newid()
selectSUBSTRING(@newid,1,8)+SUBSTRING(@newid,10,4)+SUBSTRING(@newid,15,4)+SUBSTRING(@newid,20,4)+SUBSTRING(@newid,25,12)
CREATE FUNCTION [dbo].[FunGetUUID32](@newid varchar(36)) RETURNS VARCHAR(32) AS BEGIN DECLARE @id VARCHAR(32); select @id=SUBSTRING(@newid,1,8)+SUBSTRING(@newid,10,4)+SUBSTRING(@newid,15,4)+ SUBSTRING(@newid,20,4)+SUBSTRING(@newid,25,12) RETURN @id END --使用如下 select dbo.[FunGetUUID32](NEWID());
3.直接替换
select replace(newid(),'-','');