if then statement in sql

Question

Why the if then statement is not working here

declare @num integer(2);
set @num = 10;

begin
    if (@num < 10)
    Then
        print('hello');

    set @num = @num +1 ;

    else
        print('over');

    set @num = @num +1 ;
    END IF;
END;

I get these errors:

Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'Then'.

Msg 102, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'else'.

https://stackoverflow.com/questions/15085990/can-you-have-if-then-else-logic-in-sql/15086050#15086050 — Alex, Feb 18 '17 at 08:08
Possible duplicate of [Can you have if-then-else logic in SQL?](http://stackoverflow.com/questions/15085990/can-you-have-if-then-else-logic-in-sql) — Alex, Feb 18 '17 at 08:08
If you have **more than one statement** after your `IF` or `ELSE`, you must wrap it in `BEGIN .... END` delimiters! And there's no `THEN` in T-SQL .... — marc_s, Feb 18 '17 at 08:09
Possible duplicate of [How to perform an IF...THEN in an SQL SELECT?](http://stackoverflow.com/questions/63447/how-to-perform-an-if-then-in-an-sql-select) — nhouser9, Feb 18 '17 at 08:31

Ilyes · Accepted Answer · 2017-02-18T08:12:28.497

4

Try this :

 declare @num int;
 set @num = 10;

 if (@num < 10)
 begin
   print('hello');
   set @num = @num +1;
 end
 else 
    begin
      print('over');
      set @num = @num +1;
    end

edited Feb 18 '17 at 08:12

answered Feb 18 '17 at 08:05

Ilyes

14,640
4
29
55

score 2 · Answer 2 · answered Feb 18 '17 at 08:03

2

 declare @num integer
 set @num = 10

 if (@num < 10)
 begin
   print('hello')
   set @num = @num +1
 end
 else begin
   print('over')
   set @num = @num +1
 end

answered Feb 18 '17 at 08:03

juergen d

201,996
37
293
362

if then statement in sql

2 Answers2