This documentation is archived and is not being maintained.

Script Analysis and Execution in the Transact-SQL Editor

Not only can you edit database queries and scripts in the Transact-SQL (T-SQL) editor, but also you can validate your SQL syntax, execute database queries and scripts, and examine the result sets.

In This Section

How to: Execute a Query

Describes how to run your database query or script.

How to: Set Options for Query Execution and Results

Describes how to set global options (which apply to all new T-SQL editor sessions).

Query Results Overview

Provides an overview of how you can view and work with the results that you obtain when you run your queries and scripts.

How to: Cancel a Running Query

Describes how you can terminate a long-running query instead of waiting for it to complete execution.

How to: Validate a Query without Executing

Describes how you can verify the SQL syntax of your script or query.

How to: Enable SQLCMD mode in the Transact-SQL Editor

Describes how you can enable SQLCMD mode to execute embedded SQLCMD commands in your scripts.

Editing SQLCMD Scripts in the Transact-SQL Editor

Provides an overview of how you can use SQLCMD scripts in the T-SQL editor.

How to: Control the Gathering and Display of Client Statistics

Describes how you can turn on and off the gathering and display of client statistics when you execute scripts and queries in the T-SQL editor.

Related Sections

Transact-SQL Editing Essentials

Contains topics that describe the most important editing tasks that you can perform by using the T-SQL editor.

Managing Database Connections within the Transact-SQL Editor

Contains topics that help you connect to a database server or specify a particular database in the T-SQL editor.

Walkthrough: Create and Execute a Simple Transact-SQL Script

Explains how to create and execute a simple Transact-SQL script. As part of this walkthrough, you connect and disconnect from the server, validate your T-SQL scripts, and examine the results of the query.

Overview of Transact-SQL Editor

Provides an overview of how to create, analyze, and execute scripts and queries in the T-SQL editor.