Using IntelliSense

Library

MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Getting Started
Initial Installation
Overview of SQL Server Installation
Features and Tools Overview
SQL Server Studios Overview
Introducing SQL Server Management Studio
The SQL Server Management Studio Environment
Editing Scripts and Files in SQL Server Management Studio

Using IntelliSense

Parameter Info (IntelliSense)
Quick Info (IntelliSense)
Complete Word (IntelliSense)
Automatic Matching of Syntax Pairs
How to: Modify IntelliSense Options
When IntelliSense Is Unavailable
Transact-SQL Syntax Supported by IntelliSense

Related Links

Editor Convenience Commands and Features
Navigating Code and Text
How to: Drag and Drop Text
Searching and Replacing
Using Outlining to Hide Code
Code and Text Printing Issues
How to: Manage the Editor and View Mode
How to: Manage Code Formatting
How to: Use the Properties Window in Management Studio
How to: Change Font Color, Size, and Style
Using the Transact-SQL Debugger

Using IntelliSense
SQL Server 2005

SQL Server 2008 Books Online (October 2009)

Using IntelliSense

Microsoft IntelliSense provides an array of options that make language references easily accessible. When coding, you do not need to leave the editor to perform searches on language elements. You can keep your context, find the information you need, insert language elements directly into your code, and even have IntelliSense complete your typing for you.

In This Section

Parameter Info (IntelliSense)
Quick Info (IntelliSense) (Only available in the XML editor)
Complete Word (IntelliSense)
Automatic Matching of Syntax Pairs
How to: Modify IntelliSense Options
When IntelliSense Is Unavailable

Transact-SQL Syntax Supported by IntelliSense

Note:
Enabling IntelliSense for large Transact-SQL scripts can reduce the performance of slow computers. For information about how to limit the size of Transact-SQL scripts for which IntelliSense is enabled, see Options (Text Editor/Transact-SQL/IntelliSense).

See Also

Other Resources

Editing Scripts and Files in SQL Server Management Studio

Help and Information

Getting SQL Server 2008 Assistance

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement

Rate the Lightweight library

x

Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.

Do you like the SearchBox?

Yes

No

Do you like the tabbed code blocks?

Yes

No

How useful is this topic?

Tell us more.

Thanks

x

You're helping to improve MSDN Online.

Switch View

Lightweight Beta