Lesson 2: Writing Transact-SQL

SQL Server Management Studio is an integrated development environment for writing Transact-SQL, MDX, XMLA, XML, SQL Server Compact 3.5 SP1 queries, and SQLCMD commands. The Query Editor component for writing Transact-SQL is similar to previous versions of SQL Server Query Analyzer, but it has new features that we will review in this lesson.


This lesson focuses on the features of the tool. For a tutorial on writing Transact-SQL statements, see Tutorial: Writing Transact-SQL Statements.

This lesson covers the following topics:

  • Connecting with Query Editor

  • Adding Indentation

  • Maximizing the Query Editor

  • Using Comments

  • Other Ways of Viewing the Code Window

  • Scripting a Table

  • Summary

Next Task in Lesson

Connecting with Query Editor