How to use if else in SQL Server stored procedure

Question

Stored procedure:

CREATE PROCEDURE validate
    @blockID VARCHAR(255)
AS
BEGIN
    IF @blockID = (SELECT blockID FROM block WHERE blockID = @blockID)
        PRINT 'exists'

    IF @blockID != (SELECT blockID FROM block WHERE blockID = @blockID)
        PRINT 'does not exist'

END

When input the wrong one blockID, the 2nd if conditions does not work.

@HoneyBadger sorry, forgot that :), i mean like this now – ImNewBtw Jun 11 '20 at 10:56 — ImNewBtw, Jun 11 '20 at 10:56

score 2 · Accepted Answer · answered Jun 11 '20 at 10:57

2

You probably want to use EXISTS.

CREATE PROCEDURE validate
   @blockID VARCHAR(255)
AS
BEGIN
   IF EXISTS (SELECT blockID FROM block WHERE blockID = @blockID)
      PRINT'exists'
   ELSE
      PRINT'not exists'
END

answered Jun 11 '20 at 10:57

Zhorov

28,486
6
27
52

@ImNewBtw, remember to mark Zhorov's answer as the correct answer, by selecting the tick mark next to his answer... – Attie Wagner Jun 11 '20 at 11:13

How to use if else in SQL Server stored procedure

1 Answers1