UFN_SIGNATURE_USERNAME
Gets the user name for display
Return
| Return Type |
|---|
| nvarchar(255) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SIGNERCODE | tinyint | IN | |
| @NAME | varchar(255) | IN | |
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SIGNATURE_USERNAME(
@SIGNERCODE tinyint = null,
@NAME varchar(255) = null,
@APPUSERID uniqueidentifier = null
)
returns nvarchar(255)
with execute as caller
as begin
declare @DESC nvarchar(255);
if @SIGNERCODE = 1
begin
SET @DESC = @NAME;
end
else
begin
SET @DESC = dbo.UFN_APPUSER_GETNAME(@APPUSERID);
end;
return @DESC;
end