Upgrading SQL Server - xp_execresultset

Posted by Jonathan Allen on Oct 21, 2006

Sections

Operations & Infrastructure,

Architecture & Design,

Development

Topics

SQL Server 2005 ,

SQL Server ,

Relational Databases ,

.NET ,

Data Access ,

Microsoft ,

SQL Server 2000 ,

Programming ,

Database ,

Companies

Share |

RELATED Research

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.

RelatedVendorContent

Want to know how software releases can be stress-free and happen with one click? Try Go free!

Improving Software Delivery Cycles: Pre-requisites and Inhibitors

Introducing SQLFire: a memory-optimized, high performance SQL database

Automating Error Reporting for .NET Applications

Good Relationships: The Spring Data Neo4J Guide Book

Related Sponsor

Go: Agile Release Management Solutions. Go enables predictable, defect-free and timely software releases.