USP_MAPPING_GETPRODUCTION

Gets mapping credentials for the current user.

Parameters

Parameter	Parameter Type	Mode	Description
@PRODUCTION	bit	INOUT

Definition

Copy



            create procedure dbo.USP_MAPPING_GETPRODUCTION (
                @PRODUCTION bit = null output
            ) as begin

                if exists(select 1 from dbo.MAPPINGCREDENTIALS)
                    select
                        @PRODUCTION = PRODUCTION
                    from
                        dbo.MAPPINGCREDENTIALS;

                return 0;
            end;