T-SQL编程:条件控制语句

T-SQL基础：条件控制语句

-- 流程控制语句
-- BEGIN ...END

-- IF ...ELSE

-- CASE...WHEN ... THEN...AND
begin -- 语句块
DECLARE @s datetime -- 声明变量
set @s = GETDATE () -- 赋值
select 季节 = case -- case ..and语句
when DATEPART (MM, @s ) >= 12 OR DATEPART (MM, @s ) <= 2 then ' 冬天 '
when DATEPART (MM, @s ) >= 10 then ' 秋天 '
when DATEPART (MM, @s ) >= 5 then ' 夏天 '
when DATEPART (MM, @s ) >= 3 then ' 春天 '
end
end
-- while语句
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的和: '
print @sum
-- waitfor
-- 暂时停止程序执行
waitfor delay ' 00:12:15 '
waitfor time ' 00:12:15 '

转载于:https://www.cnblogs.com/school/archive/2011/05/03/2034920.html