USP_BANKINGSYSTEM_GETBYID

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CONDITIONSETTINGNAME	nvarchar(50)	INOUT
@CONDITIONSETTINGENABLED	bit	INOUT
@NAME	nvarchar(50)	INOUT

Definition

Copy



create procedure dbo.USP_BANKINGSYSTEM_GETBYID
(
    @ID uniqueidentifier,
    @CONDITIONSETTINGNAME nvarchar(50) output,
    @CONDITIONSETTINGENABLED bit output,
    @NAME nvarchar(50) output
)
as
begin
    set nocount on;

    select
        @CONDITIONSETTINGNAME = BANKINGSYSTEM.CONDITIONSETTINGNAME,
        @CONDITIONSETTINGENABLED = BANKINGSYSTEM.CONDITIONSETTINGENABLED,
        @NAME = BANKINGSYSTEM.NAME
    from
        dbo.UFN_BANKINGSYSTEM_BANKINGSYSTEMSLIST(1) BANKINGSYSTEM
    where
        BANKINGSYSTEM.ID = @ID;

end