How to retrieve complete query from few combinations. RRS feed

  • Question

  • Hi guys.

    I have a stored procedure that combine query from a few IF...ELSE statements.

    During the combination, some errors occurred. So I would like to take a look of the final query.

    Is it possible to do so? Thanks.

    Thursday, April 15, 2010 4:00 PM


  • No, unless it's dynamically built  SQL. In that case you could use PRINT statement inside of stored procedure. You could debug stored procedure in SQL Server Management studio that would help you to troubleshoot error

    Val Mazur (MVP)
    Friday, April 16, 2010 9:47 AM