Database Engine Query Editor (SQL Server Management Studio)
Use the Database Engine Query Editor to create and run scripts containing Transact-SQL statements. The editor also supports running scripts that contain sqlcmd commands.
The Database Engine Query Editor supports linking you to the reference topic for a specific Transact-SQL statement when you select F1. To do so, highlight the name of a Transact-SQL statement and then select F1. The help search engine will then search for a topic that has an F1 help attribute that matches the string you highlighted.
If the help search engine does not find a topic with an F1 help keyword that exactly matches the string you highlighted, then this topic is displayed. In that case, there are two approaches to finding the help you are looking for:
Copy and paste the editor string you highlighted into the search tab of SQL Server Books Online and do a search.
Highlight only the part of the Transact-SQL statement likely to match an F1 help keyword applied to a topic and select F1 again. The search engine requires an exact match between the string you highlighted and an F1 help keyword assigned to a topic. If the string you highlighted contains elements unique to your environment, such as column or parameter names, the search engine will not get a match. Examples of the strings to highlight include:
The name of a Transact-SQL statement, such as SELECT, CREATE DATABASE or BEGIN TRANSACTION.
The name of a built-in function, such as SERVERPROPERTY, or @@VERSION.
The name of a system stored procedure table, or view, such as sys.data_spaces or sp_tableoption.
The Database Engine Query Editor is one of four editors implemented in SQL Server Management Studio. For a description of the functionality implemented in the Database Engine Query Editor and the main tasks you can perform using the editor, see Query and Text Editors (SQL Server Management Studio).
When the Database Engine Query Editor is open, the SQL Editor toolbar appears with the following buttons.
You can also add the SQL Editor toolbar by selecting the View menu, selecting Toolbars, and then selecting SQL Editor. If you add the SQL Editor toolbar when no Database Engine Query Editor windows are open, all the buttons are unavailable.