Lesson 2: Writing Transact-SQL
SQL Server 2005
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
