Skip to content

lesson-2-writing-transact-sql.md

Latest commit

 

History

History
39 lines (27 loc) · 1.27 KB

lesson-2-writing-transact-sql.md

File metadata and controls

39 lines (27 loc) · 1.27 KB
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

[!INCLUDEssManStudioFull] is an integrated development environment for writing [!INCLUDEtsql], MDX, DMX, and XML queries, and SQLCMD commands. The tutorial illustrates using the Database Engine Query Editor to write a [!INCLUDEtsql] script.

Note

This lesson focuses on the features of the tool. For a tutorial on writing [!INCLUDEtsql] 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

Next Task in Lesson

Connecting with Query Editor