IntelliSense is a general term for various code editing features including: code completion, parameter info, quick info, and member lists. IntelliSense features are sometimes called by other names such as 'code completion', 'content assist', and 'code hinting.'
- Oct 27, 2014 Installing SQL Server Data Tools - Business Intelligence for Visual Studio 2013 also installs the following, if they are not already installed on the computer: Microsoft.NET Framework 4.5.1 Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package.
- Previously (for Visual Studio.NET 2003 and Visual Studio 2005) it was a separate SKU that supported only Visual C# and Visual Basic languages or was included in the Team Suite. With Visual Studio 2008, it is no longer a separate SKU but is included with Professional and higher editions.
IntelliSense for your programming language
Visual Studio Business Intelligence Integration Services
For SQL 2012 (Visual Studio 2010 and Visual Studio 2012) and SQL 2014 (Visual Studio 2013), though release 1.7.0 works, we recommend moving development to Visual Studio 2017 which is backwards compatible with SQL 2012 and SQL 2014. For Visual Studio 2017, install BI Developer Extensions from the Visual Studio gallery using the instructions above.
Below are the most popular language extensions in the Marketplace. Click on an extension tile below to read the description and reviews to decide which extension is best for you.
VS Code IntelliSense features are powered by a language service. A language service provides intelligent code completions based on language semantics and an analysis of your source code. If a language service knows possible completions, the IntelliSense suggestions will pop up as you type. If you continue typing characters, the list of members (variables, methods, etc.) is filtered to only include members containing your typed characters. Pressing Tab or Enter will insert the selected member.
Tip: The suggestions widget supports CamelCase filtering, meaning you can type the letters which are upper cased in a method name to limit the suggestions. For example, 'cra' will quickly bring up 'createApplication'.
If you prefer, you can turn off IntelliSense while you type. See Customizing IntelliSense below to learn how to disable or customize VS Code's IntelliSense features.
As provided by the language service, you can see quick info for each method by either pressing ⌃Space (Windows, Linux Ctrl+Space) or clicking the info icon. The accompanying documentation for the method will now expand to the side. The expanded documentation will stay so and will update as you navigate the list. You can close this by pressing ⌃Space (Windows, Linux Ctrl+Space) again or by clicking on the close icon.
After choosing a method you are provided with parameter info.
When applicable, a language service will surface the underlying types in the quick info and method signatures. In the image above, you can see several
any suggests that the variable can be of any type.
Types of completions
VS Code IntelliSense offers different types of completions, including language server suggestions, snippets, and simple word based textual completions.
|Methods and Functions|
|Properties and Attributes|
|Values and Enumerations|
You can customize your IntelliSense experience in settings and key bindings.
The settings shown below are the default settings. You can change these settings in your
settings.json file as described in User and Workspace Settings.
The editor supports 'tab completion' which inserts the best matching completion when pressing Tab. This works regardless of the suggest widget showing or not. Also, pressing Tab after inserting a suggestions will insert the next best suggestion.
By default, tab completion is disabled. Use the
editor.tabCompletion setting to enable it. These values exist:
off- (default) Tab completion is disabled.
on- Tab completion is enabled for all suggestions and repeated invocations insert the next best suggestion.
onlySnippets- Tab completion only inserts static snippets which prefix match the current line prefix.
Sorting of suggestions depends on extension information and on how well they match the current word you are typing. In addition, you can ask the editor to boost suggestions that appear closer to the cursor position, using the
In above images you can see that
colocated are sorted based on the scopes in which they appear (loop, function, file).
By default, VS Code pre-selects the previously used suggestion in the suggestion list. This is very useful as you can quickly insert the same completion multiple times. If you'd like different behavior, for example, always select the top item in the suggestion list, you can use the
editor.suggestSelection values are:
first- Always select the top list item.
recentlyUsed- (default) The previously used item is selected unless a prefix (type to select) selects a different item.
recentlyUsedByPrefix- Select items based on previous prefixes that have completed those suggestions.
'Type to select' means that the current prefix (roughly the text left of the cursor) is used to filter and sort suggestions. When this happens and when its result differs from the result of
recentlyUsed it will be given precedence.
When using the last option,
recentlyUsedByPrefix, VS Code remembers which item was selected for a specific prefix (partial text). For example, if you typed
co and then selected
console, the next time you typed
co, the suggestion
console would be pre-selected. This lets you quickly map various prefixes to different suggestions, for example
Snippets in suggestions
By default, VS Code shows snippets and completion proposals in one widget. You can control the behavior with the
editor.snippetSuggestions setting. To remove snippets from the suggestions widget, set the value to
'none'. If you'd like to see snippets, you can specify the order relative to suggestions; at the top (
'top'), at the bottom (
'bottom'), or inline ordered alphabetically (
'inline'). The default is
The key bindings shown below are the default key bindings. You can change these in your
keybindings.json file as described in Key Bindings.
Note: There are many more key bindings relating to IntelliSense. Open the Default Keyboard Shortcuts (File > Preferences > Keyboard Shortcuts) and search for 'suggest'.
If you find IntelliSense has stopped working, the language service may not be running. Try restarting VS Code and this should solve the issue. If you are still missing IntelliSense features after installing a language extension, open an issue in the repository of the language extension.
A particular language extension may not support all the VS Code IntelliSense features. Review the extension's README to find out what is supported. If you think there are issues with a language extension, you can usually find the issue repository for an extension through the VS Code Marketplace. Navigate to the extension's detail page and click the
Visual Studio Business Intelligence 2013
IntelliSense is just one of VS Code's powerful features. Read on to learn more:
- Node.js - See an example of IntelliSense in action in the Node.js walkthrough.
- Debugging - Learn how to set up debugging for your application.
- Creating Language extensions - Learn how to create extensions that add IntelliSense for new programming languages.
Microsoft Visual Studio Business Intelligence
Why am I not getting any suggestions?
Why am I not seeing method and variable suggestions?
Visual Studio Business Intelligence 2017