T-SQL Testing Options

  • Just curious - what are the various options available for testing t-sql code in stored procedures?

    Specifically how can one step through code as would be done with a .net application.

    Any advice would be greatly appreciated.

    Thanks

  • kimreyj (5/9/2013)


    Just curious - what are the various options available for testing t-sql code in stored procedures?

    Specifically how can one step through code as would be done with a .net application.

    Any advice would be greatly appreciated.

    Thanks

    If you talking about testing SQL, then there are 3rd-party solutions to help with it. I guess most commonly used is SQL Test from RedGate (http://www.red-gate.com/products/sql-development/sql-test/)

    "Steping" through code is not a "testing" but "debugging"! You can use SSMS Debug (there is a menu there on the same level as File...).

    As from the older school, I debug manually by simply adding some debug lines (print, select or dedicated procedure)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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