Running 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.
To run selected text
- Open either a stored procedure or user-defined function in the editor.
- Position the cursor over a block of SQL text in the editor.
- Choose Design SQL Block on the shortcut menu.
The Query Designer displays the block of SQL text in the SQL pane.
- Right-click the text in the SQL pane and choose Run on the shortcut menu.