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 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..
|