Post reply

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

  • 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

  • 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

  • February 1, 2011 at 3:15 am

    #1280808

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

    Just checking!

    Thanks 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply