| title | Lesson 1: Creating Database Objects | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| applies_to |
|
|
| ms.assetid | 9fb8656b-0e4e-4ada-b404-4db4d3eea995 | |
| caps.latest.revision | 20 | |
| author | BYHAM | |
| ms.author | rickbyh | |
| manager | jhubbard |
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: