T-SQL programming: Conditional Control statements

T-SQL basics: condition control statements

-- Process control statement
-- BEGIN... END
  
-- IF... ELSE
  
-- CASE... WHEN... THEN... AND
Begin -- Statement Block
DECLARE @ s datetime -- DECLARE the variable
Set @ s = GETDATE () -- Value assignment
Select season = case -- case... and statement
When DATEPART (MM, @ s)> = 12 or datepart (MM, @ s) <= 2 then 'Winter'
When DATEPART (MM, @ s)> = 10 then 'loan'
When DATEPART (MM, @ s)> = 5 then 'summer'
When DATEPART (MM, @ s)> = 3 then 'spring'
End
End
-- While statement
Declare @ I int, @ sum int
Select @ I = 1, @ sum = 0
While @ I <100
Begin
Select @ sum = @ sum + @ I
Select @ I = @ I + 1
End

Print '1 + 2... + 100 and :'
Print @ sum
-- Waitfor
-- Temporarily stop Program Execution
Waitfor delay '00: 12: 15'
Waitfor time '00: 12: 15'

 

T-SQL basics: condition control statements

-- Process control statement
-- BEGIN... END
  
-- IF... ELSE
  
-- CASE... WHEN... THEN... AND
Begin -- Statement Block
DECLARE @ s datetime -- DECLARE the variable
Set @ s = GETDATE () -- Value assignment
Select season = case -- case... and statement
When DATEPART (MM, @ s)> = 12 or datepart (MM, @ s) <= 2 then 'Winter'
When DATEPART (MM, @ s)> = 10 then 'loan'
When DATEPART (MM, @ s)> = 5 then 'summer'
When DATEPART (MM, @ s)> = 3 then 'spring'
End
End
-- While statement
Declare @ I int, @ sum int
Select @ I = 1, @ sum = 0
While @ I <100
Begin
Select @ sum = @ sum + @ I
Select @ I = @ I + 1
End

Print '1 + 2... + 100 and :'
Print @ sum
-- Waitfor
-- Temporarily stop Program Execution
Waitfor delay '00: 12: 15'
Waitfor time '00: 12: 15'