Executing SQL Statements in SQL Query Analyzer
You can execute a complete script or only selected SQL statements in SQL Query Analyzer.
- Execute a complete script by creating or opening the script in the Editor pane and pressing F5.
- Execute only selected SQL statements by highlighting the lines of code in the Editor pane and pressing F5.
You can also easily execute a SELECT statement containing a built-in function. Right-click the function in Object Browser, select Script Object to New Window As, and select Execute. A SELECT statement containing the function is displayed in a new Editor pane. If the function contains arguments, they are displayed in template parameter format. Press CTRL+SHIFT+M to display the Replace Template Parameters dialog box and supply values for the function arguments. Press F5 to execute the SELECT statement.