Export (0) Print
Expand All

Executing SQL Statements in SQL Query Analyzer

SQL Server 2000

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.

© 2015 Microsoft