Editing Database Scripts and Objects with the Transact-SQL Editor

You can edit, validate, and execute database queries, scripts and objects by using the Transact-SQL (T-SQL) editor in Visual Studio Team Edition for Database Professionals.

In This Section

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

• 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.

• 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 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.

Related Sections

• 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 Team Edition for Database Professionals.

• Creating and Updating Version-controlled Database Schemas
  Describes how you can use database projects in combination with version control software to manage database change. This section includes overviews of how you can use database projects in a team environment, how database developers can set up isolated development environments in which to work, and how you can define, build, and deploy database objects.

• Working with Database Scripts
  Contains topics that describe how you create and maintain scripts for deploying database schemas and managing databases.

• Renaming Database Objects
  Contains links to information about how to rename database objects. Contains links to an overview, important considerations, tasks, and troubleshooting information.

• Verifying Databases with Unit Tests
  Describes how you can use database unit testing to verify whether database objects, such as stored procedures and triggers, behave as you expect. When you perform unit tests in combination with using Data Generator, you can test for predictable results.

• Comparing Databases
  Describes how you can use Data Compare to identify similarities and differences in the data that is contained in two databases. This section also describes how you can use Schema Compare to identify structural differences between databases or between a database and a database project. After you compare either data or schemas, you can then update a target to match a source.