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 SP2 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
Maximizing the Query Editor
Other Ways of Viewing the Code Window
Scripting a Table