Facilitating the spread of knowledge and innovation in professional software development



Choose your language

InfoQ Homepage News Upgrading SQL Server - xp_execresultset

Upgrading SQL Server - xp_execresultset


SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. This function takes a query that creates a set of intermediate queries. These intermediate queries are then executed. This function is especially useful when you need to execute a stored procedure against multiple rows. Unfortunately for those already using it, SQL Server 2005 has dropped this feature.

Adam Machanic has come to the rescue with ExecResultSet. This handy little proc duplicates the functionality of xp_execresultset.


We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.