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.

  • 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 beneath possible code errors. They disappear when the possible errors are fixed.


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.