| title | Lesson 1: Creating Database Objects | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-non-specified | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.service | ||
| ms.component | t-sql | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| applies_to |
|
|
| ms.assetid | 9fb8656b-0e4e-4ada-b404-4db4d3eea995 | |
| caps.latest.revision | 20 | |
| author | edmacauley | |
| ms.author | edmaca | |
| manager | craigg | |
| ms.workload | On Demand |
[!INCLUDEtsql-appliesto-ss2008-all-md] This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using [!INCLUDEtsql], it does not use or describe the many options that are available for these statements.
[!INCLUDEtsql] statements can be written and submitted to the [!INCLUDEssDE] in the following ways:
-
By using [!INCLUDEssManStudioFull]. This tutorial assumes that you are using [!INCLUDEssManStudio], but you can also use [!INCLUDEssManStudio] Express, which is available as a free download from the Microsoft Download Center.
-
By using the sqlcmd utility.
-
By connecting from an application that you create.
The code executes on the [!INCLUDEssDE] in the same way and with the same permissions, regardless of how you submit the code statements.
To run [!INCLUDEtsql] statements in [!INCLUDEssManStudio], open [!INCLUDEssManStudio] and connect to an instance of the [!INCLUDEssDEnoversion].
This lesson contains the following topics: