Debug query in SSMS


As we all are aware with debugging and have used it while testing our queries or troubleshooting .  Now in  SQL 2008 its possible to debug our queries in SSMS.



Its simple and easy. Lets see how to do it.

In toolbar we have toolbar of Debug , if not we can open it as below




Now we will run below query in SSMS

DECLARE @I INT

SET @I = 1

WHILE @I <= 100
    BEGIN
        PRINT @I

        SET @I = @I + 1
    END


Now start debugging as shown below


Open watch window as show below




Now create breakpoints in the query, by clicking at starting of the row.





Type parameter @i in the Name field of watch window. Monitor the value of @i in the watch window.





Ok fine. Now I want to jump the value . I want to set its value to some new number
See below how to modify it. Modify it and start debugging.
Is it simple :-)















No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts