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