UFN_ADHOCQUERY_GETID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@NAME nvarchar(255) IN

Definition

Copy



create function [dbo].[UFN_ADHOCQUERY_GETID] (@NAME as nvarchar(255))
returns uniqueidentifier
with execute as caller
as
begin
    declare @return_value uniqueidentifier
    select @return_value=ID from dbo.ADHOCQUERY where NAME = @NAME
    return @return_value
end