Control Structures

Control structures syntax; IF THEN ELSE, CASE, WHILE .

IF THEN ELSE

The IF THEN ELSE syntax in TSQL is kinda weird if you ask me … I forget them ‘all the time’, created examples below for my reference.

IF THEN
if 1 = 1
begin 
  print 'true'
end

go
IF THEN – short notation
if 1 = 1
  print 'true'

go
IF THEN ELSE
if 1 = 1
begin
  print 'true'
end

else  
 
begin
  print 'false'
end

go
IF THEN ELSE – short notation
if 1 = 1
  print 'true'
else  
  print 'false'
 
go
Multiple IF THEN ELSE blocks
if 1 = 1
begin
  print '1 = 1'
end
else  
if 1 = 2
  begin
    print '1 = 2'
  end
else
if 1 = 3
begin
  print '1 = 3'
end

go

CASE

TSQL has the CASE control structure …

declare @i int, @r int

set @i = 1


set @r = 
  case @i
    when 1 then 1
    when 2 then 2
      else 0
  end

print @r


go

WHILE

Eternal loop
while 1 = 1 
  print 'true'

go
Simple WHILE loop
declare @i int
set @i = 0

while @i < 10
begin
  print @i
  set @i = @i + 1
end

go

One thought on “Control Structures

Leave a Reply

Your email address will not be published. Required fields are marked *