471,089 Members | 1,232 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

how to use sp_cursoropen

I meet the problem when I use sp_cursoropen.
the sample like:
declare @P1 int, @rowcount int
exec sp_cursoropen @P1 output,'select name,id from syscolumns', @scrollopt=1, @ccopt=1

the output will give the field name "name id" without any data.
Anyway to remove this output. I don't want to show the fields name on the output.
Apr 25 '07 #1
0 2734

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

19 posts views Thread by Thue Tuxen Sørensen | last post: by
4 posts views Thread by Richard | last post: by
1 post views Thread by kmounkhaty | last post: by
5 posts views Thread by peppi911 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.