Lesson 2: Writing Transact-SQL

SQL Server Management Studio is an integrated development environment for writing Transact-SQL, MDX, XMLA, XML, SQL Server Compact Edition 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.

Note

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

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
• SQLCMD Mode
• Summary

Next Task in Lesson

Connecting with Query Editor