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 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.

ms166585.note(en-US,SQL.90).gifNote:
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

Community Additions

ADD
Show:
© 2014 Microsoft