declare @cursor_name varchar(36),@str nvarchar(4000)
0select @cursor_name=newid()
DECLARE @ckbm varchar(20)
exec( DECLARE [ @cursor_name ] CURSOR FOR 0select f_ckbm from tbda_ck )
exec( open [ @cursor_name ] )
set @str=N fetch from [ @cursor_name ] into @ckbm
exec sp_executesql @str,N @ckbm varchar(20) out ,@ckbm out
while @@fetch_status = 0
begin
print @ckbm
exec sp_executesql @str,N @ckbm varchar(20) out ,@ckbm out
end
exec( close [ @cursor_name ] )
exec( deallocate [ @cursor_name ] )
|