Upgrading SQL Server - xp_execresultset
- Share
-
- |
Read later
My Reading List
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.
Community comments
Educational Content
Large-Scale Continuous Testing in the Cloud
John Penix May 24, 2013
.jpg)
Managing Build Jobs for Continuous Delivery
Martin Peston May 24, 2013
Clojure in the Field
Stuart Halloway May 23, 2013
Hello stranger!
You need to Register an InfoQ account 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