BT

Upgrading SQL Server - xp_execresultset

by Jonathan Allen on Oct 21, 2006 |

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.

 

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.

Tell us what you think

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

Email me replies to any of my messages in this thread
Community comments

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

Email me replies to any of my messages in this thread

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

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT