python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions