Post reply

System stored procedure to return empty resultset of the particular user defined stored procedure.

  • February 10, 2010 at 6:24 am

    #216614

    I am searching one system stored procedure, which returns an empty resultsets of the particular user defined stored procedure.

    E.g.

    If I have stored procedure which is returning 2 resultsets like

    ResultSet 1:

    ID | Name

    ResultSet 2 :

    Address | City | State

    When I execute this stored procedure with parameters it will return resultsets with data.

    My requirement is that I need blank resultsets for further procedure.

    I think there is one system procedure,which return blank resultset.

    Regards,

    BJ

  • February 10, 2010 at 12:15 pm

    #1117069

    Your requirement is not clear at all.

    Why would someone run a procedure to get empty result sets?

    What you could do is to add a WHERE 1=2 clause to each of your two SELECTS.

    This will return empty result sets.

    I still question the business case though...

    I don't recall any system procedure that would actually do stuff like that.


    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 1 (of 1 total)

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