by Hello All,
Greetings...
Please create the Stored Proc below in 6.5 and 7.0 in the PUBS Database
and see the Result Sets. I found the problem when was migrating one of
the stored procs in our 6.5 DB.
***********STORED PROC BEGIN **********************
drop proc nkcurTest
go
create proc nkcurTest
as
print "****SELECT VARIABLE assigned before DECALRE CURSOR****"
declare curtest cursor for
select au_id , au_lname from authors
open curtest
begin
end
close curtest
deallocate curtest
print ""
print "****SELECT VARIABLE assigned after DECALRE CURSOR before, OPEN
CURSOR****"
declare curtest1 cursor for
select au_id , au_lname from authors
open curtest1
begin
end
close curtest1
deallocate curtest1
go
***********STORED PROC END **********************
I would like to know if any of u have a similar problem and the
possible resolution to this. IS it a BUG or is this how works in SQL
7.0???
Any thoughts would be helpful.
Thanks
NK
Sent via Deja.com http://www.deja.com/
Before you buy.