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());