Export (0) Print
Expand All

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.

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft