JY数据库流程与控制
USE JY
GO
1. IF…ELSE语句
DECLARE @a int, @m int
SELECT @n = 1, @m = 9
IF(@n > @m)
PRINT @n
ELSE
PRINT @m
GO
2. CASE语句
- 注释的语句为简单的CASE语句
- 搜索CASE语句,查看变量值为10时对应的字符
DECLARE @n int, @ch varchar(10)
SET @n = 10
SET @ch = CASE --SET @ch = CASE @n
WHEN @n = 2 THEN 'a' --WHEN 2 THEN 'a'
WHEN @n = 5 THEN 'b' --WHEN 5 THEN 'b'
WHEN @n = 6 THEN 'g' --WHEN 6 THEN 'g'
WHEN @n = 8 THEN 's' --WHEN 8 THEN 's'
ELSE 'o' --ELSE 'o'
END
PRINT @ch
GO
3. WHILE语句
DECLARE @n int, @sum int
SELECT @n = 1, @sum = 0 --对变量赋值
WHILE @n <= 100 --当@n <= 100执行循环体
BEGIN
SELECT @sum = @sum + @n --求和
SELECT @n = @n + 1 --计数单元
END
SELECT '1+2+3+...+100的和' = @sum
GO
4. WAITFOR语句
DECLARE @name varchar(10)
SET @name = 'SQL Server' --变量赋值
BEGIN
WAITFOR DELAY '00:00:10' --设置程序停止的时长
PRINT @name --打印变量
END
GO