---
title: "Lesson 2: Writing Transact-SQL | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: ssms
ms.topic: conceptual
ms.assetid: 439cfab5-c049-43a8-8617-59eaa8d24873
author: stevestein
ms.author: sstein
manager: craigg
---
# Lesson 2: Writing Transact-SQL
  [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] is an integrated development environment for writing [!INCLUDE[tsql](../../includes/tsql-md.md)], MDX, DMX, and XML queries, and SQLCMD commands. The tutorial illustrates using the Database Engine Query Editor to write a [!INCLUDE[tsql](../../includes/tsql-md.md)] script.  
  
> [!NOTE]  
>  This lesson focuses on the features of the tool. For a tutorial on writing [!INCLUDE[tsql](../../includes/tsql-md.md)] statements, see [Tutorial: Writing Transact-SQL Statements](../../t-sql/tutorial-writing-transact-sql-statements.md).  
  
 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  
  
## Next Task in Lesson  
 [Connecting with Query Editor](lesson-2-1-connecting-with-query-editor.md)