I have a stored proc I'd like to debug in the SQL Server 2008 management studio. I see a number of tutorials about doing this, but the ones I've se开发者_如何学Cen don't have any input parameters going into the SP. My SP has several, and an output parameter as well.
Could someone show me how to do debug a stored procedure with parameters in SQL 2008? Thanks very much.
Just write a query that correctly invokes your SP and debug that:
exec MySP p1 p2 etc
精彩评论