Transact-SQL Editing Essentials
You will want to perform certain important operations in the Transact-SQL (T-SQL) editor, such as modifying the definition of a database object, creating a pre-deployment script, or modifying a management script.
In This Section
How to: Start the Transact-SQL Editor
Describes several methods by which you can start the T-SQL editor to create, modify, or execute script.
Keyboard Shortcuts for the Transact-SQL Editor
Lists the keyboard shortcuts that you can use in the T-SQL editor.
Syntax Coloration in the Transact-SQL Editor
Describes how you can interpret the color coding in the T-SQL editor.
How to: Save a Query or Script
Describes how you can save changes that you have made to a query or a script.
Overview of Transact-SQL Editor
Provides an overview of how to create, analyze, and execute scripts and queries in 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.
Script Analysis and Execution in the Transact-SQL Editor
Contains topics that help you analyze and run your scripts and queries in the T-SQL editor.
Walkthrough: Create and Execute a Simple Transact-SQL Script
Explains how to create and execute a simple T-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.
Terminology Overview of Database Edition
Describes terminology associated with the features of Visual Studio Team System Database Edition.
Getting Started with Visual Studio Team Edition for Database Professionals
Provides overviews, introductory walkthroughs, glossary definitions, and other basic information to help you start to learn about Database Edition.
Working with Database Scripts
Contains topics that describe how you create and maintain scripts for deploying database schemas and managing databases.
Scenario: Create and Modify Database and Server Objects
Provides an overview and links to topics that describe how you create, modify, and validate changes to database objects such as tables, stored procedures, and functions.
For information about standard features in the Visual Studio editor, see the following topics:
Editor Convenience Commands and Features
Describes how to manipulate code and text in the editor.
Editing Text, Code, and Markup
Describes how to use the editor to write and format code.
Navigating Through Code
Provides links to procedures for using the Find and Replace window, Bookmarks, and the Task List and Error List windows to locate lines of code.
Customizing the Editor
Describes how to customize the editor by setting editor options.