create procedure test as
declare @year varchar(50)
select @year=param from info
select * from @year
...全文
2699打赏收藏
求表名可变的存储过程的写法
我想写个存储过程,其中select from后的表名是不固定的,需要从另外一个表取得,我设计以下写法,但是不行说“必须声明变量 '@year'。” 我没辙了,请高手解惑,谢谢 create procedure test as declare @year varchar(50) select @year=param from info select * from @year
create procedure test as
declare @year varchar(50)
declare hyc cursor for select param from info
open hyc
while @@fetch_status=0
begin
fetch next from info into @year
exec('select * from '+ @year)
end
close hyc
deallocate hyc