Anil Singh | Code-sample.com

Hello Everyone,   I am going to share the code sample to use of If else in stored procedure SQL Server. The query as given below.   /*      * IF ELSE IN STORED PROCEDURE SQL SERVER.      * USER OF NOT-IN  in SQL SERVER. */ ALTER PROCEDURE [dbo] . [SP_VALIDATE_ACCOUNT] (    @ACCOUNTID VARCHAR ( 40 ) = 'ACT9979' ,    @STATUS CHAR ( 1 ) OUT ) AS BEGIN IF NOT EXISTS ( SELECT ACCOUNTID FROM [DBO] . [ACCOUNTNUMBER] WHERE ID = @ACCOUNTID )     BEGIN            SET @STATUS = 'Y'     END ELSE     BEGIN            SET @STATUS = 'N'            RETURN @STATUS     END    END