1、if语句
declare @i int
set @i = 0
if(@i <= 10)
begin
print @i
end
else
begin
print 'haha'
end
2、while语句
declare @i int
set @i = 1
while (@i<30)
begin
select ‘哈哈’
set @i = @i + 1
end
图1 游标代码 图2 运行结果3、游标循环
1、if语句
declare @i int
set @i = 0
if(@i <= 10)
begin
print @i
end
else
begin
print 'haha'
end
2、while语句
declare @i int
set @i = 1
while (@i<30)
begin
select ‘哈哈’
set @i = @i + 1
end
图1 游标代码 图2 运行结果3、游标循环
本文标题:SQL中循环与条件语句
本文链接:https://www.haomeiwen.com/subject/bkqlrftx.html
网友评论