22,210
社区成员
发帖
与我相关
我的任务
分享
declare @A int
declare @B int
select @A = 1
select @B = 2
if @A = 1
begin
select @A = 12
select @B = @B-1
end
else
select @A = @A-1
--多条件分支可以用
case when 条件1 then 语句1
when 条件2 then 语句2
when 条件3 then 语句3
else '语句4'
end
declare @A int
declare @B int
select @A =1
select @B = 2
if @A = 1
begin
select @A = 12
select @B = @B-1
end
else
begin
select @A = @A-1
end
declare @A int
declare @B int
select @A =1
select @B = 2
if @A = 1
select @A = 12,@B = @B-1
else
select @A = @A-1
declare @A int
declare @B int
select @A = 1
select @B = 2
if @A = 1
begin
select @A = 12
select @B = @B-1 --(注:此句报错,无法执行)
end
else
select @A = @A-1
if @A = 1
begin
select @A = 12
select @B = @B-1 (注:此句报错,无法执行)
end
else
select @A = @A-1
declare @A int
declare @B int
select @A = 1
select @B = 12
if @A = 1
begin
select @A = 12
select @B = @B-1
end
else
begin
select @A = @A-1
end