Scalar-valued Functions [dbo].[uuid_from_char]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@uuidvarchar(36)36
Permissions
TypeActionOwning Principal
GrantExecuteupmuser_group
GrantExecutepublic
GrantExecuteca_itrm_group
GrantExecuteca_itrm_group_ams
GrantExecuteupmadmin_group
SQL Script
/****** Object:  User Defined Function dbo.uuid_from_char    Script Date: 12/1/2005 11:50:34 PM ******/



/* Star 14448560 ADD FUNCTION UUID_FROM_CHAR */
CREATE FUNCTION [dbo].[uuid_from_char]( @uuid varchar(36) )
returns uniqueidentifier
as
begin
    return convert(uniqueidentifier,@uuid)
end
GO
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [ca_itrm_group]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [ca_itrm_group_ams]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [public]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [upmadmin_group]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [upmuser_group]
GO
Uses