UFN_MERGETASKCATALOG_GETSPNAME
Retrieves the name of a merge task's stored procedure.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MERGETASKCATALOG_GETSPNAME(@ID uniqueidentifier)
returns nvarchar(100)
as
begin
declare @RETURNVALUE nvarchar(100);
select @RETURNVALUE = SPNAME from dbo.MERGETASKCATALOG where ID = @ID;
return @RETURNVALUE;
end