Use T-SQL Editor to Edit & Execute Scripts

The Transact-SQL Editor provides you with a rich editing and debugging experience when

you’re working with scripts. It’s invoked when you use the

contextual menu to open

a database entity in a connected database or a project. It’s also automatically opened when

you use the

contextual menu from the SQL Server Object Explorer, or add a new

script object to a database project.

If you aren’t connected to a database, but want to execute a query against it, you can also use

the

dialog box in the

menu option to

connect to a database and launch the Transact-SQL Editor.

The Transact-SQL Editor contains a main

pane where you can write and edit Transact-

SQL scripts. The editor supports IntelliSense and color coding of syntax to improve the

readability of complex statements. It also supports find and replace, bulk commenting, custom

fonts and colors, and line numbering. You can also change the database which the script in the

editor is executed against. For more information, see

How to: Clone an Existing Database. The

pane displays query results in a grid or text. You can also redirect these query results to

a file. The

pane displays errors, warnings, and informational messages returned when

a script is run. When client statistics is enabled, the

pane displays information about

the query execution grouped into categories. The

pane displays the data

retrieval methods chosen by SQL Server, and shows the execution cost of specific statements

and queries.

Description

How to: Outline and Add Snippets to

Transact-SQL Script

Use the Snippet Picker to insert ready-made Transact-SQL code

to your query.

How to: Navigate Between Scripts

Use Go-To-Definition and Find All Reference to navigate between

scripts.

How to: Use rename and refactoring

to make changes to your database

objects

Rename an object across all scripts and preview any changes.

ﾉ

Expand table