How to: Run Selected Text in Stored Procedures and User-Defined Functions

You can run selected text in stored procedures and user-defined functions. This is a convenient way to validate portions of your SQL syntax as you build a complex query.


Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

To run selected text

  1. Open either a stored procedure or user-defined function in the editor..

  2. Select the text in the SQL Editor, right-click it, and then click Run Selection on the shortcut menu.

Community Additions