retrieving one big XML column via stored proc: output param or recordset?

• Eric Mamet

  SSChampion

  Points: 11728

  More actions

  February 1, 2011 at 3:05 am

  #144573

  Dear all,

  I want to retrieve one XML column from a table via a stored procedure on a server and fire another stored proc on another server (via SSIS).

  I will then call my target stored procedure with the XML passed as an INPUT parameter.

  I expect my XML should be a couple of megabytes.

  I think I can do this with either a OUTPUT parameter or as a single column single row recordset returned.

  Is there any particular reason to prefer one or the other?

  Thanks

  Eric

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  February 1, 2011 at 3:12 am

  #1280805

  Well, there is no such differentiation between returning the XML as OUTPUT or in SELECT, it won't make any difference in OUTPUT size. It 2 GB max in either case.

  Here the process is retriving the value from one SP & passing it to another one, in this case the better option could be returning the value in XML output clause.

  Abhijit - http://abhijitmore.wordpress.com

• Eric Mamet

  SSChampion

  Points: 11728

  More actions

  February 1, 2011 at 3:15 am

  #1280808

  To be honest, I expected that kind of answer...

  Just checking!

  Thanks