USP_TASKCATALOG_GETINFO
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TASKCATALOGID | uniqueidentifier | IN | |
| @TASKNAME | nvarchar(100) | INOUT | |
| @FUNCTIONALAREANAME | nvarchar(100) | INOUT |
Definition
Copy
create procedure dbo.USP_TASKCATALOG_GETINFO
(
@TASKCATALOGID uniqueidentifier,
@TASKNAME nvarchar(100) = null output,
@FUNCTIONALAREANAME nvarchar(100) = null output
)
as
begin
set nocount on;
select
@TASKNAME = TASKCATALOG.NAME,
@FUNCTIONALAREANAME = FUNCTIONALAREACATALOG.NAME
from
dbo.TASKCATALOG
inner join dbo.FUNCTIONALAREACATALOG on FUNCTIONALAREACATALOG.ID = TASKCATALOG.FUNCTIONALAREAID
where
TASKCATALOG.ID = @TASKCATALOGID;
end