SQL Server 2012 Transact-SQL DML Reference.pdf

Microsoft SQL Server 2012

Transact-SQL DML Reference

SQL Server Books Online

Summary : Data Manipulation Language (DML) is a vocabulary used to

retrieve and work with data in SQL Server 2012. Use these statements to

add, modify, query, or remove data from a SQL Server database.

Category: Reference

Applies to : SQL Server 2012

Source : SQL Server 2012 Books Online ( link to source content )

E-book publication date : May 2012

263 pages

without the written permission of the publisher.

Microsoft and the trademarks listed at

http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the

Microsoft group of companies. All other marks are property of their respective owners.

The example companies, organizations, products, domain names, email addresses, logos, people, places, and events

depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,

logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided without any

express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will

be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Contents

Data Manipulation Language (DML) Statements..........................................................................3

BULK INSERT.............................................................................................................................4

DELETE....................................................................................................................................16

FROM .......................................................................................................................................27

Hints .........................................................................................................................................43

Join Hints...............................................................................................................................43

Query Hints............................................................................................................................45

Table Hints ............................................................................................................................58

INSERT.....................................................................................................................................74

MERGE...................................................................................................................................100

OPTION Clause ......................................................................................................................114

OUTPUT Clause .....................................................................................................................114

READTEXT.............................................................................................................................130

Search Condition.....................................................................................................................132

SELECT..................................................................................................................................137

SELECT Clause...................................................................................................................140

SELECT Examples ..............................................................................................................143

FOR Clause .........................................................................................................................157

GROUP BY..........................................................................................................................163

HAVING...............................................................................................................................173

INTO Clause ........................................................................................................................174

ORDER BY Clause ..............................................................................................................179

OVER Clause ......................................................................................................................190

Table Value Constructor ..........................................................................................................201

TOP ........................................................................................................................................205

UPDATE .................................................................................................................................212

UPDATETEXT ........................................................................................................................240

WHERE ..................................................................................................................................244

WITH common_table_expression ............................................................................................246

WRITETEXT ...........................................................................................................................257

Transact-SQL Syntax Conventions ..........................................................................................260

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: