Board index MS SQL Server

Question on cursors in store proc used by several process simultaneously

Question on cursors in store proc used by several process simultaneously

Post by darre » Thu, 10 Jun 1999 04:00:00



Dear All:
 Recently I met a problem on SQL server cursor. I want to know if there are
any problems for me to use cursor as the following mechanism: in a store
procedure I open a cursor,use it and close it after I finish using it. In
using the the cursor I will use "fetch next" to get next row. Then I judge


since there are several processes will call this store proc simultaneously,

Please help me to confirm the globle variable can be used in this scenario
or not.

 
 
 
Top

Question on cursors in store proc used by several process simultaneously

Post by Tobias Thernstr? » Thu, 10 Jun 1999 04:00:00


It should not be a problem since the global var is bound to each
session. I.e Connection 1 using FETCH NEXT will not change

Hope this helps.
--
Tobias Thernstr?m
MCSE, MCT
Digitask Sweden AB


> Dear All:
>  Recently I met a problem on SQL server cursor. I want to know if there
are
> any problems for me to use cursor as the following mechanism: in a store
> procedure I open a cursor,use it and close it after I finish using it. In
> using the the cursor I will use "fetch next" to get next row. Then I judge


But
> since there are several processes will call this store proc
simultaneously,
> and in the store proc I analyze the value of the globle variable


> Please help me to confirm the globle variable can be used in this scenario
> or not.


 
 
 
Top

1. Using a stored proc to call another stored proc

I'm using SQL Server 7.0.  I've got a stored proc that returns a resultset.
I would like another stored proc to be able to call it and cycle through
that resultset.  Can I do even do this, or should I rethink my design?

Thanks, Jon

2. Problem with date field

3. Need column names in JDBC Meta-Data for a UDB Stored Proc using cursor

4. helllllllllllllllppppp

5. using ADO and calling a stored proc, prob w/ cursor

6. CAPTURE SQL SCRIPT

7. Using Cursors with a Stored Proc

8. Simplest and quickest OPS setup required..

9. newbie-- how to return proc values to another proc to be used in a cursor

10. simultaneously update db2 database from several client machines?

11. Several procedures using the same proc.

12. using stored proc results in other proc or select

13. Question on using a stored proc & DTS


All times are UTC
Board index