Lesson 2: Writing Transact-SQL

SQL Server Management Studio is an integrated development environment for writing Transact-SQL, MDX, DMX, and XML queries, and SQLCMD commands. The tutorial illustrates using the Database Engine Query Editor to write a Transact-SQL script.

PLEASE NOTE!! This lesson focuses on using SSMS while working with T-SQL statements, not on how to write T-SQL statements! For a tutorial on writing Transact-SQL statements, see Tutorial: Writing Transact-SQL Statements.

This lesson covers the following topics:

Next Task in Lesson

Connecting with Query Editor