run stored procedure inside cursor.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

run stored procedure inside cursor.

Author

Topic

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-05-04 : 17:48:59

I want to run stored procedure inside cursor for the parameters supplied? How can i do it? Any examples will be helpful.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-04 : 17:50:05

Why do you want to use a cursor? Why can't it be done in sets instead?

There are cursor examples in SQL Server Books Online.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-05-04 : 18:19:23

any examples?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-04 : 20:55:21

quote:
There are cursor examples in SQL Server Books Online

Not sure what was unclear about that. Books Online is the standard documentation installed with SQL Server. You should always look there first before posting a question on a forum.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources