问如何将table1改为一个变量

[我看你有戏]

declare @id int
Declare CurCfg Cursor For select id from table1
Open CurCfg
Fetch next From CurCfg Into @id
While @@fetch_status=0
Begin
--print @id
Fetch Next From CurCfg Into @id
End
Close CurCfg
Deallocate CurCfg

drop table #tmp

[--小F--]

不解..

[忆轩辕]

动态SQL？

[我看你有戏]

我的意思是table1可以让我当成过程的参数传进来啊

[Zoezs]

存储没办法传表变量。

[nianran520]

动态拼接吧

[-狙击手-]

仿这个：

declare   @sql   varchar(8000),@tablename   sysname   
  set   @sql   =   'declare   csr_test   cursor   for   select   *   from   '+   @tablename   
  exec   (@sql)   
  open   csr_test   
  fetch   next   from   csr_test     
  close   csr_test   
  deallocate   csr_test

[-狙击手-]

declare @s varchar(1000) 
declare   @sql   varchar(8000),@tablename   sysname  
set @tablename = 'ta' 
set @sql = 'declare csr_test cursor for select 商品 from   '+   @tablename   
exec(@sql)   
open csr_test   
fetch next from  csr_test into @s  
while @@fetch_status = 0
begin
	print @s
	fetch csr_test into @s
end 
close   csr_test   
deallocate   csr_test
/*

衣服
衣服
衣服
鞋子
鞋子
鞋子
裤子
裤子
裤子
帽子
帽子
帽子

*/