[dbo].[uniqueidentifier_from_char]
CREATE FUNCTION [dbo].[uniqueidentifier_from_char](@uuid varchar(36) )
RETURNS uniqueidentifier
AS
BEGIN
if (CHARINDEX('-', @uuid) = 0)
begin
select @uuid = substring(@uuid,1,8) + '-' +
substring(@uuid,9, 4) + '-' +
substring(@uuid,13,4) + '-' +
substring(@uuid,17,4) + '-' +
substring(@uuid,21,12);
select @uuid = convert(uniqueidentifier, @uuid)
end
return @uuid
END
GO
GRANT EXECUTE ON [dbo].[uniqueidentifier_from_char] TO [aiadmin]
GO
