SQL statements can be difficult to diagnose and debug. SQL Server does not include any default way to debug and step through a stored procedure, but Visual Studio does. Using the Server Explorer, you can step through the execution of a stored procedure or function right inside of Visual Studio. The first step is to open the Server Explorer and create a data connection to your database. You will then see the stored procedures and functions of your database listed in the Server Explorer. From the Server Explorer, you can right-click on a stored procedure or function and you will see a menu...

Visual Studio offers a powerful debugger to aid with testing and troubleshooting your applications. One of the most common uses of a debugger is to set breakpoints, which are positions in the code that, when reached, cause the program execution to pause, allowing the developer to inspect the code and state of the program. When a breakpoint is reached and the application suspended, the application is in break mode. In break mode, you, the developer, can examine and change the values of the program variables. The simplest way to add a breakpoint to a particular line of code is to click in the margin...

Normally when you use “ctrl + f” and search for results, you have to navigate one by one in every file where the searched string exists. There is an alternative to this rather than navigating one by one you can have all the results in your “find window”. press ctrl + shft + f you can search for the string and the result will be displayed in the Find window you can click on the search result line to navigate to that part. This is extremely helpful when you want all your results to be listed in a find window rather then to navigate one by one in every file where the searched...

Many a times you find the need to navigate to the function definition from the function call to see how the function has been defined. To do this you can either press F12 or right click on function call and select “Go to definition” option. Similarly from the function definition to go back to the function call press ctrl + – keys.

Regular expressions are an extremely versatile text-matching language that gives you incredible power when searching your documents and when used with replace operations, can greatly assist with repetitive changes to blocks of code. The basic regular expression search is easily done. You simply open the Find dialog through the Edit – Find and Replace – Find menu or with Ctrl-F (Edit.Find). Enable regular expression searching by ensuring the Use checkbox is selected and the drop-down list has Regular Expressions selected. Enter your regular expression into the Find What text...