asked on
ALTER PROCEDURE TEST
@ConsumerID nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Description NVARCHAR (255)=NULL;
SELECT C.ConsumerName
FROM Consumers C
WHERE C.ConsumerID = N'A1'
IF @@ROWCOUNT>0
BEGIN
PRINT'Founded'
END
IF
((SELECT C.ConsumerID
FROM Consumers C
WHERE C.ConsumerID = N'A1')= N'No')
BEGIN
SET @Description = N'Not ON GSB';
END
ELSE
BEGIN
SET @Description = N'YES ON GSB';
END
ELSE
BEGIN
PRINT N'Not Found'
END
END