Editor Convenience Commands and Features
The Microsoft SQL Server Management Studio editors have several new convenience commands and features to help you administer your server or develop applications. Some features are not available in all types of Query editors.
- Incremental Search. A search is performed on a letter-by-letter basis as you type. To activate an incremental search, press CTRL+I.
- IntelliSense. When a function or stored procedure is entered into a query, its complete syntax and arguments are shown in a ToolTip. For more information, see Using IntelliSense. This feature is not available for Transact-SQL scripts.
- Line Numbering. Display line numbers in code. You can do this on a per-language basis or for all languages. After line numbering has been activated, you can go to a particular line by clicking Go To on the Edit menu, or by pressing CTRL+G. For more information, see Navigating Code and Text.
- Hyperlinks in comments. You can embed URLs in your comment lines. This feature is useful, for example, for adding a link to a Web page that contains a code specification or a Help topic.
- Squiggles. Squiggles are wavy lines, similar to the squiggles in Microsoft Word that appear in the MDX, DMX, and XML editors beneath possible code errors. They disappear when the possible errors are fixed.
Note
For a complete list of keyboard shortcut keys for both the standard and SQL Server 2000 keyboard schemes, see SQL Server Management Studio Keyboard Shortcuts.
See Also
Concepts
Writing, Analyzing, and Editing Scripts with SQL Server Management Studio
Customizing Menus and Shortcut Keys
Other Resources
Editing Scripts and Files in SQL Server Management Studio