--例子:
create proc p_test
@tbname sysname --表名
as
exec('declare 游标名 cursor for select * from '+@tbname)
open 游标名close 游标名
deallocate 游标名
go
create proc p_test
@tbname sysname --表名
as
exec('declare 游标名 cursor for select * from '+@tbname)
open 游标名close 游标名
deallocate 游标名
go
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