SQL Server 2012入门教程：编写Transact-SQL语句

需积分: 10 84 浏览量更新于2024-07-19 收藏 422KB PDF 举报

本教程是针对Microsoft SQL Server 2012的新手用户，主要关注"写作Transact-SQL语句"这一主题。Transact-SQL是Microsoft对SQL标准的实现，它在SQL Server 2012中占据了核心地位。该教程旨在为初学者提供一个快速入门，通过讲解创建表和插入数据等基础操作，让读者对Transact-SQL语言有一个基本的了解。教程特别强调，它并不是一个全面的Transact-SQL课程的替代品，而是侧重于简单易懂的实例，以便用户能在日常数据库操作中快速上手。所包含的语句设计得较为基础，不反映典型生产环境中可能遇到的复杂性。这是一本"快速步骤"式的指南，适用于SQL Server 2012环境。《SQL Server 2012教程：编写Transact-SQL语句》由微软公司在2012年6月发布，版权归属于微软公司，所有内容未经书面许可不得复制或传播。教程链接可以直接从SQL Server Books Online获取原始内容。值得注意的是，本教程遵循了Microsoft的商标政策，其详细信息可在微软官方网站的知识产权和商标列表中查询。学习这本教程，用户可以掌握如何使用Transact-SQL进行基本的数据管理，包括但不限于创建表结构、插入记录，以及理解SQL查询的基本语法和逻辑。这对于那些初次接触SQL Server 2012的开发人员和管理员来说，是一个实用且有效的学习资源。然而，对于想要深入理解和处理大型、复杂数据库的用户，可能还需要进一步学习更高级的Transact-SQL特性及最佳实践。

Tutorial: Writing Transact-SQL Statements

Welcome to the Writing Transact-SQL Statements tutorial. This tutorial is intended for users who

are new to writing SQL statements. It will help new users get started by reviewing some basic

statements for creating tables and inserting data. This tutorial uses Transact-SQL, the Microsoft

implementation of the SQL standard. This tutorial is intended as a brief introduction to the

Transact-SQL language and not as a replacement for a Transact-SQL class. The statements in

this tutorial are intentionally simple, and are not meant to represent the complexity found in a

typical production database.

Novice users of databases will usually find it easier to work with SQL Server by using SQL

Server Management Studio, instead of writing Transact-SQL statements.

Finding More Information

To find more information about any specific statement, either search for the statement by name

in SQL Server Books Online, or use the Contents to browse the 1,800 language elements listed

alphabetically under

Transact-SQL Reference (Database Engine). Another good strategy for

finding information is to search for key words that are related to the subject matter you are

interested in. For example, if you want to know how to return a part of a date (such as the

month), search the index for dates [SQL Server], and then select dateparts. This takes you to

the topic

DATEPART (Transact-SQL). As another example, to find out how to work with strings,

search for string functions. This takes you to the topic

String Functions (Transact-SQL).

What You Will Learn

This tutorial shows you how to create a database, create a table in the database, insert data into

the table, update the data, read the data, delete the data, and then delete the table. You will

create views and stored procedures and configure a user to the database and the data.

This tutorial is divided into three lessons:

Lesson 1: Creating Database Objects

In this lesson, you create a database, create a table in the database, insert data into the table,

update the data, and read the data.

Lesson 2: Configuring Permissions on Database Objects

In this lesson, you create a login and user. You will also create a view and a stored procedure,

and then grant the user permission to the stored procedure.

Lesson 3: Deleting Database Objects

In this lesson, you remove access to data, delete data from a table, delete the table, and then

delete the database.

Note

剩余20页未读，继续阅读

打工脱贫

粉丝: 0
资源: 12

SQL Server 2012入门教程：编写Transact-SQL语句

create sql statement

Transact-SQL编程

Transact-SQL 编程

SQL Server 2012 Tutorials - Transact SQL DML Reference

SQL Server 2012 Tutorials - Reporting Services

SQL Server 2012 Tutorials - Analysis Services Multidimensional Modeling

SQL Server 2012 Tutorials - Analysis Services Tabular Modeling

SQL-Server-2012-Tutorials---Analysis-Services-Dat_Windows编程_C#_

tutorials-c11-console-apps-mhaviland：tutorials-c11-console-apps-mhaviland由GitHub Classroom创建

tutorials-master_编程多语言_tutorials-master_

最新资源