开发者

Debugging stored procedure in SQL Server 2008 Management Studio

开发者 https://www.devze.com 2022-12-23 15:34 出处:网络
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 go

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
0

精彩评论

暂无评论...
验证码 换一张
取 消