Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

Show:
© 2015 Microsoft