In this video that I will share with you, I would like to demonstrate a very interesting feature in the development of T-SQL queries and code, especially functions and Stored Procedures, which is DEBUG.
A very common and popular tool for developers on a daily basis (and hardly used when context is database programming), Debug lets you track code execution step by step, providing us with useful information to help you understand how it works. of a code and assisting in identifying and resolving potential errors or deviations from functionality, such as tracking the current values of each scope variable as the code is executed.
Without further ado, follow the video below:
Well guys, I hope you enjoyed this video, a big hug and until the next post.
Perfect! These are very important contents in my daily life and whenever I need to refer to a format or process, I recommend people to access and evaluate what Dirceu has done..
Hello Dirceu, I really like your publications, I'm always following you, congratulations on your great work.
Just a doubt in the Management Studio debug, is that when I'm debugging a procedure, I identify the error, change the procedure, and when I post it again, the MS does not understand the change and continues debugging the old procedure. Did it already happen to you?
In sql server management 2020 I didn't find the option to Debug.
Hello, the debug option was removed on ssms 18 .. If you want to use it, you have to download version 17
Very cool the theme! Congratulations.
Glad you liked it and thanks for this feedback 🙂