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

CREATE FUNCTION [dbo].[uuid_to_char](@string uniqueidentifier )  
RETURNS varchar(36) AS  
BEGIN
     RETURN CONVERT(varchar(36), @string)
END
GO
GRANT EXECUTE ON  [dbo].[uuid_to_char] TO [ca_itrm_group]
GRANT EXECUTE ON  [dbo].[uuid_to_char] TO [public]
GRANT EXECUTE ON  [dbo].[uuid_to_char] TO [upmadmin_group]
GRANT EXECUTE ON  [dbo].[uuid_to_char] TO [upmuser_group]
GO
Uses