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