-
sp_cursoropen
declare @P1 int set @P1=180150000
declare @P2 int set @P2=1
declare @P3 int set @P3=16388
declare @P4 int set @P4=4
exec sp_cursoropen
@P1 output,
N'Select * from MyTable
Where LoggedOn = ''Y''' ,
@P2 output,
@P3 output,
@P4 output
select
@P1 as 'Cursor',
@P2 as 'ScrollOption',
@P3 as 'ConcurrencyOption',
@P4 as 'RowCount'
- What happens when exec sp_cursoropen gets run consecutively & numerously (with the same command)?
- Does exec sp_cursoropen have to have a corresponding "sp_cursorclose" ?
-Anybody experience with these system procedures? thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|