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.
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