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
Maximizing the Query Editor
Other Ways of Viewing the Code Window
Scripting a Table