Share via


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.

Note

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 Visual Studio Settings.

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.

See Also

Other Resources

Working with Stored Procedures and User-Defined Functions

Designing Queries and Views