Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Lesson 2: Writing Transact-SQL


Applies To: SQL Server 2016 Preview

SQL Server Management Studio is an integrated development environment for writing Transact-SQL, MDX, DMX, and XML queries, and SQLCMD commands. The tutorial illustrates using the Database Engine Query Editor to write a Transact-SQL script.


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

© 2015 Microsoft