|
Features
|
Professional
|
Standard
|
 |
Compatibility
|
|
|
|
SQL Server 2022
|
ⅴ
|
ⅴ
|
|
SQL Server 2005 - 2019
|
ⅴ
|
|
|
SQL Server 2000
|
ⅴ!
|
ⅴ!
|
|
SQL Server installed on Linux
|
ⅴ
|
ⅴ
|
|
Azure SQL Database (SQL DB)
|
ⅴ
|
ⅴ
|
|
Azure SQL Data Warehouse (SQL DW)
|
ⅴ
|
ⅴ
|
|
Azure SQL Managed Instance (SQL MI)
|
ⅴ
|
ⅴ
|
|
Azure Active Directory (Azure AD) multi-factor authentication (MFA)
|
ⅴ
|
ⅴ
|
|
Microsoft Visual Studio 2012 - 2019
|
ⅴ
|
ⅴ
|
|
SQL Server Management Studio 2014, 2016, 17, 18, 19
|
ⅴ
|
ⅴ
|
|
SQL Server Management Studio 2012
|
ⅴ!
|
ⅴ!
|
|
|
|
|
 |
Intelligent SQL Completion
|
|
|
|
Smart suggestions
|
ⅴ
|
ⅴ
|
|
Wise filtering in the suggestion list
|
ⅴ
|
ⅴ
|
|
Database context detection
|
ⅴ
|
ⅴ
|
|
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET,
and USE statements
|
ⅴ
|
ⅴ
|
|
Parameter information for functions
|
ⅴ
|
ⅴ
|
|
Semi-transparent view of the suggestion box
|
ⅴ
|
ⅴ
|
|
Prompting common table expressions (CTE)
|
ⅴ
|
ⅴ
|
|
Context-sensitive suggestion of keywords
|
ⅴ
|
ⅴ
|
|
Quick object information
|
ⅴ
|
ⅴ
|
|
Name suggestions for objects on linked servers
|
ⅴ
|
ⅴ
|
|
Column picker for quick list building
|
ⅴ
|
ⅴ
|
|
JOIN clause auto generation
|
ⅴ
|
ⅴ
|
|
Wildcard expansion
|
ⅴ
|
ⅴ
|
|
INSERT, EXEC, and ALTER statements expansion
|
ⅴ
|
ⅴ
|
|
UPDATE statements expansion
|
ⅴ
|
ⅴ
|
|
Auto-generation of table aliases
|
ⅴ
|
ⅴ
|
|
Context-sensitive object suggestions for T-SQL code, DDL, and security
statements
|
ⅴ
|
ⅴ
|
|
SQL snippets
|
ⅴ
|
ⅴ
|
|
Code completion in SQLCMD mode
|
ⅴ
|
ⅴ
|
|
Identifier occurrences highlighting
|
ⅴ
|
ⅴ
|
|
Sorting suggested keywords by relevance
|
ⅴ
|
ⅴ
|
|
Custom alias mapping
|
ⅴ
|
ⅴ
|
|
Phrase completion
|
ⅴ
|
ⅴ
|
|
Pair highlighting (BEGIN END; CASE END)
|
ⅴ
|
ⅴ
|
|
Highlight of matching COLUMNS and VALUES in the INSERT statement
|
ⅴ
|
ⅴ
|
|
Show popup with column name in the values area for INSERT statement
|
ⅴ
|
ⅴ
|
|
Get Row Count
|
ⅴ
|
ⅴ
|
|
Expanding sp_executesql
|
ⅴ
|
ⅴ
|
|
Named Regions
|
ⅴ
|
ⅴ
|
|
Data Sensitivity Classification suggestions
|
ⅴ
|
ⅴ
|
|
SSDT Project
|
ⅴ
|
ⅴ
|
|
|
|
|
 |
T-SQL Formatting
|
|
|
|
SQL formatting
|
ⅴ
|
ⅴ
|
|
Database identifier case synchronization
|
ⅴ
|
ⅴ
|
|
Word recognition in CamelCase identifiers
|
ⅴ
|
ⅴ
|
|
SQL Formatting command-line interface
|
ⅴ
|
|
|
Formatting in files and directories
|
ⅴ
|
ⅴ
|
|
Adjust keyword case on typing
|
ⅴ
|
ⅴ
|
|
Disable formatting for a block of code (noformat tag)
|
ⅴ
|
ⅴ
|
|
Wide range of predefined formatting profiles
|
ⅴ
|
ⅴ
|
|
|
|
|
 |
Code Refactoring
|
|
|
|
Enclosing needed identifiers in square brackets
|
ⅴ
|
|
|
Smart rename
|
ⅴ
|
|
|
Semicolon insertion
|
ⅴ
|
|
|
T-SQL Debugger
|
ⅴ
|
|
|
Find invalid objects
|
ⅴ
|
|
|
|
|
|
 |
Productivity Extension
|
|
|
|
Execution History
|
ⅴ
|
|
|
Execute current statement
|
ⅴ
|
|
|
"Go to definition" for database objects
|
ⅴ
|
|
|
Document outline window
|
ⅴ
|
|
|
Statement navigation
|
ⅴ
|
|
|
Execution warnings
|
ⅴ
|
|
|
CRUD generator
|
ⅴ
|
|
|
Convert EXEC to script
|
ⅴ
|
|
|
Run script on multiple databases
|
ⅴ
|
|
|
Execution notifications
|
ⅴ
|
|
|
Transaction reminder
|
ⅴ
|
|
|
Find in Results Grid
|
ⅴ
|
|
|
Grid Aggregates
|
ⅴ
|
|
|
Navigation between the BEGIN and END pair
|
ⅴ
|
|
|
Navigation between BEGIN TRY/END TRY
|
ⅴ
|
|
|
Navigation between BEGIN CATCH/END CATCH
|
ⅴ
|
|
|
Navigation between CASE and END
|
ⅴ
|
|
|
Navigation between COLUMNS and VALUES in the INSERT statement
|
ⅴ
|
|
|
Generate Script As from SSMS data grid
|
ⅴ
|
|
|
Restore last document session
|
ⅴ
|
|
|
Custom SSMS main window title & SQL document tabs caption
|
ⅴ
|
|
|
Close unmodified tabs
|
ⅴ
|
|
|
Tabs coloring as well as Status bar and Object explorer coloring
|
ⅴ
|
|
|
Script object as CREATE/ALTER
|
ⅴ
|
|
|
Excluding databases from prompts
|
ⅴ
|
|
|
Copy Results Grid Headers (Column Names + Types)
|
ⅴ
|
|
|
Results Grid Data Visualizers
|
ⅴ
|
|
|
Proportional tab width and the ability to control what is displayed in
the tab name
|
ⅴ
|
|
