skip to content
Posts · December 2020

SQL Server UUID


create function [dbo].uuid(@id varchar(36))
returns varchar(48)
as
begin
declare @ret varchar(48)
select @ret=format(getdate(),'yyyyMMddHHmmss')+lower(replace(@id,'-',''))
return @ret
end
select dbo.uuid(NEWID())