THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Scripts » SQL Server 2005   (RSS)
Sorry, but there are no more tags available to filter with.
  • Replacing xp_execresultset in SQL Server 2005

    SQL Server 2000 included a very useful extended stored procedure called xp_execresultset. This XP had two parameters: @cmd and @dbname. @cmd was expected to be a SELECT statement that would produce a single column of output, each row of which would produce a valid query. @dbname was used to specify the database that both the initial query and ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 19, 2006
Privacy Statement