If else in stored procedure sql server

If else in stored procedure sql server

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
    BEGIN
           SET @STATUS ='N'
           RETURN @STATUS
    END  

END
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^