Drop Table #abcd
if @login=true
select * into #abcd from syspara where code='01'
else
select * into #abcd from syspara where code='02'
if @login=true
select * into #abcd from syspara where code='01'
else
select * into #abcd from syspara where code='02'
select * into #abcd from syspara where code='01'
else
select * into #abcd from syspara where code='02'
select * into #abcd from syspara
where code=case @login when 1 then '01' else '02 end
select * into #abcd from syspara
where code=case @login when 1 then '01' else '02' end
drop table #abcd
select * into #abcd from syspara
where code=(case when @login=1 then '01' else '02' end)
所以以上方法都不行sqlserver为什么不让过程中出现两条活以上的创建同一个表的名字的语句呢,这几条语句是单项执行的也不行吗?根据条件可是只有一条才被执行的啊
if @login=true
select * into #abcd from syspara where code='01'
else
select * into #abcd from syspara where codext='01'这句该怎么变呢?
select * into #abcd from syspara
where code=case @login when 1 then '01' else '02' end
drop table #abcd
select * into #abcd from syspara
where code=case @login when 1 then '01' else '02' end
if @a>b
select * into #abcd ...where ...
else
select * into #abcd ...where ...
然后再写你的语句就可以拉。if @login=true
insert into #abcd select * from syspara where code='01'
else
insert into #abcd select * from syspara where code='02'