UFN_RESOURCE_GETCATEGORY
Returns the category description of a resource, or the resource name if category not given.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_RESOURCE_GETCATEGORY(@ID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin
declare @RESOURCECATEGORYDESCRIPTION nvarchar(100);
declare @RESOURCECATEGORYID uniqueidentifier = (select RESOURCECATEGORYCODEID from dbo.RESOURCE where ID = @ID)
select @RESOURCECATEGORYDESCRIPTION = DESCRIPTION from dbo.RESOURCECATEGORYCODE where ID = @RESOURCECATEGORYID;
if @RESOURCECATEGORYID is null or @RESOURCECATEGORYDESCRIPTION = ''
select @RESOURCECATEGORYDESCRIPTION = NAME from dbo.RESOURCE where ID = @ID
return @RESOURCECATEGORYDESCRIPTION
end