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
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To run selected text
Open either a stored procedure or user-defined function in the editor..
Select the text in the SQL Editor, right-click it, and then click Run Selection on the shortcut menu.