USP_DATALIST_CLIENTS

Get organization details

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN	ClientsID

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_CLIENTS(@ID Int = null)
      as
          set nocount on;

          select ID,
                 NAME
          from dbo.CLIENTS
          where ID = ISNULL(@ID,ID)