How to use the Visual Studio CLR Debugger

This article will explain in detail how to use the Visual Studio CLR debugger. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

CLR debugger method 1: use test scripts

Another way is to create a test script and then debug the test script. After the test script is created, save it in the Test Scripts folder in the solution. The following is an example of the code in the Test1.sql script, where we will run the sortString function with the string value specified below as an argument.

Select dbo.sortString ('apple,pear,orange,banana,grape,kiwi')

After setting the breakpoint, right-click the test script and select "Debug Script" from the pop-up menu to start debugging.

It is important to note that when testing with a test script, you must set a breakpoint, otherwise the debugger will not stop until all the code has been executed.

Once the debugging process begins, it stops at * breakpoints, as shown in figure 2.

At this point, we can step through the lines of code for each step line by line and see the numerical value change.

CLR Debugger method 2: test with an application

In this method, Visual Studio is used to debug the application. The program acts as a test driver, and if the application calls the CLR code of SQL Server and a breakpoint is set in the CLR code, we can debug the code.

This is the end of the article on "how to use the Visual Studio CLR Debugger". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.