fnLoginName

Return

Return Type
nvarchar(50)

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN

Definition

Copy



            CREATE Function [dbo].[fnLoginName](@PKID int) returns nvarchar(50) as
            begin
                declare @name nvarchar(50)

                Select top 1 @name = UserName
                from [dbo].ClientUsers
                where ID=@PKID

                return @name
            end