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.

System_CAPS_ICON_note.jpg Note

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

Connecting with Query Editor