UFN_EXPORTDEFINITION_GETID

Returns the ID of an export definition given its name.

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy


create function dbo.UFN_EXPORTDEFINITION_GETID(@NAME nvarchar(200))
returns uniqueidentifier
with execute as caller
as begin

    declare @ID uniqueidentifier

    select @ID = ID from dbo.EXPORTDEFINITION where EXPORTDEFINITION.NAME = @NAME;

    return @ID
end