Home Forums SQL Server 2008 T-SQL (SS2K8) T-SQL Testing Options RE: T-SQL Testing Options

  • May 10, 2013 at 3:11 am

    #1614099

    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]