UFN_CLIENTS_GETNAME_BYID

Returns name on client record by ID.

Return

Return Type
nvarchar(510)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



            create function dbo.UFN_CLIENTS_GETNAME_BYID(
                @ID int
            )
            returns nvarchar(510)
            with execute as caller
            as begin
                declare @NAME nvarchar(510)
                select @NAME = [NAME]
                from dbo.[CLIENTS]
                where [ID] = @ID

                return @NAME;
            end