UFN_SESSION_GETNAME
Returns the name of a given session.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SESSIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SESSION_GETNAME(@SESSIONID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin
-- do work here and return a value
return (
select
DESCRIPTION
from
dbo.SESSION
join dbo.SESSIONNAMECODE on SESSIONNAMECODE.ID = SESSION.SESSIONNAMECODEID
where
SESSION.ID = @SESSIONID)
end