Sql Server 生成32位uuid

来源:互联网 发布:悟空助手mac电脑版 编辑:程序博客网 时间:2024/06/05 02:26


CREATE FUNCTION [dbo].[fun_getUUID32](@newid varchar(36))RETURNS VARCHAR(32)ASBEGINDECLARE @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 @idEND

select dbo.fun_getUUID32(NEWID());


0 0