Post reply

Using OutPut Parameters in SP calls

  • June 14, 2010 at 9:18 am

    #225604

    Hi,

    I am checking if there are any restrictions in using OUTPUT parameter.

    I am having one existing SP which contains a OUTput parameter as a last parameter. Now I need to add one more default parameter after the Output parameter as I don't know where else this SP is being used.

    Also while calling SP, is there any restriction that OUtput parameter should be the last parameter in the SP execute statement?

    Thanks,

    Suresh

    Regards,
    Suresh Arumugam

  • June 14, 2010 at 2:00 pm

    #1180086

    Based on BOL there is no restriction. So, in theory, it shouldn't matter.

    Did you try it using a simple sproc? Wouldn't such a test be easier than asking a theoretical question?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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