UFN_APPUSER_GETNAME
Return
| Return Type |
|---|
| nvarchar(128) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_APPUSER_GETNAME(@ID uniqueidentifier) returns nvarchar(128)
AS
BEGIN
declare @NAME nvarchar(128);
select @NAME = case when DISPLAYNAME = '' then USERNAME else DISPLAYNAME end from dbo.APPUSER where ID = @ID;
RETURN @NAME;
END