如果两者要联合,可以: select * from test union select * from test2 但要保证列对应类型一致。
带个参数吧 这样: create proc ptest(@a varchar(20)) as declare @sql nvarchar(1000) if(@a=xxx) set @sql='select * from test' else set @sql='select * from test2' exec @sql
create proc ptest as select * from test union all select * from test2 go
select * from test
union
select * from test2
但要保证列对应类型一致。
这样:
create proc ptest(@a varchar(20))
as
declare @sql nvarchar(1000)
if(@a=xxx)
set @sql='select * from test'
else
set @sql='select * from test2'
exec @sql
as
select * from test
union all
select * from test2
go