declare @a varchar (20)
declare @b varchar (20)
set @a='a1'
if @a='a1'
select @b='b1'
else
select @a='a2',
@b='b2'select @a,@b 结果
-------------------- --------------------
a1 b1(1 行受影响)
declare @b varchar (20)
set @a='a1'
if @a='a1'
select @b='b1'
else
select @a='a2',
@b='b2'select @a,@b 结果
-------------------- --------------------
a1 b1(1 行受影响)
declare @b varchar (20)
set @a='a2'
if @a='a1'
select @b='b1'
else
select @a='a2',
@b='b2'select @a,@b
结果
-------------------- --------------------
a2 b2(1 行受影响)
set @a = 'a1,a2,...'
set @b = 'b1,b2,...'
就是怎么写语句能够一一对应 谢谢