Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

T-SQL Testing Options Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 6:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 2, 2014 1:21 AM
Points: 8, Visits: 181
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
Post #1451387
Posted Friday, May 10, 2013 3:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:23 AM
Points: 2,873, Visits: 5,189
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!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1451481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse