SQL IF ELSE BEGIN END

IF (a > 1)
     SET @b = 1 + 2
 INSERT INTO #F (a, b, c) VALUES (1, 2, 3)

IF (a > 1)
   BEGIN
     SET @b = 1 + 2
     INSERT INTO #F (a, b, c) VALUES (1, 2, 3)
   END

IF (a > 1)
BEGIN
   SET @b = 1 + 2
   INSERT INTO #F (a, b, c) VALUES (1, 2, 3)
END

IF (A > 1)
BEGIN
  SET @B = 1 + 2
  INSERT INTO #F(a, b, c) VALUES (1, 2, 3)
END

Declare @a as int
Declare @b as int
Set @a = 2
If (@a > 1) Set @b = 1 + 2 Select 'Select Reached'

Declare @a as int
Declare @b as int
Set @a = 2
If (@a > 1)
BEGIN
    Set @b = 1 + 2
END
Select 'Select Reached'

Declare @a as int
Declare @b as int
Set @a = 1
If (@a > 1) begin Set @b = 1 + 2 end Select 'Select Reached'
if (@a <= 1) begin Set @b = 1 + 2 end Select 'Select not Reached'