@@ -18,33 +18,32 @@ ms.author: "rickbyh"
1818manager : " jhubbard"
1919---
2020# Queries
21- [ !INCLUDE[ tsql-appliesto-ss2012-xxxx-xxxx-xxx_md] ( ../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md )]
2221
23- Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in [ !INCLUDE[ ssCurrent] ( ../../includes/sscurrent-md.md )] . Use these statements to add, modify, query, or remove data from a [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] database.
24-
25- ## In This Section
26- The following table lists the DML statements that [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] uses.
27-
28- |||
29- | -| -|
30- | [ BULK INSERT ( ; Transact-SQL) ; ] ( ../../t-sql/statements/bulk-insert-transact-sql.md ) | [ SELECT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/select-transact-sql.md ) |
31- | [ DELETE ( ; Transact-SQL) ; ] ( ../../t-sql/statements/delete-transact-sql.md ) | [ UPDATE ( ; Transact-SQL) ; ] ( ../../t-sql/queries/update-transact-sql.md ) |
32- | [ INSERT ( ; Transact-SQL) ; ] ( ../../t-sql/statements/insert-transact-sql.md ) | [ UPDATETEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/updatetext-transact-sql.md ) |
33- | [ MERGE ( ; Transact-SQL) ; ] ( ../../t-sql/statements/merge-transact-sql.md ) | [ WRITETEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/writetext-transact-sql.md ) |
34- | [ READTEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/readtext-transact-sql.md ) ||
35-
36- The following table lists the clauses that are used in multiple DML statements or clauses.
37-
38- | Clause| Can be used in these statements|
39- | ------------| -------------------------------------|
40- | [ FROM ( ; Transact-SQL) ; ] ( ../../t-sql/queries/from-transact-sql.md ) | DELETE, SELECT, UPDATE|
41- | [ Hints ( ; Transact-SQL) ; ] ( ../../t-sql/queries/hints-transact-sql.md ) | DELETE, INSERT, SELECT, UPDATE|
42- | [ OPTION Clause ( ; Transact-SQL) ; ] ( ../../t-sql/queries/option-clause-transact-sql.md ) | DELETE, SELECT, UPDATE|
43- | [ OUTPUT Clause ( ; Transact-SQL) ; ] ( ../../t-sql/queries/output-clause-transact-sql.md ) | DELETE, INSERT, MERGE, UPDATE|
44- | [ Search Condition ( ; Transact-SQL) ; ] ( ../../t-sql/queries/search-condition-transact-sql.md ) | DELETE, MERGE, SELECT, UPDATE|
45- | [ Table Value Constructor ( ; Transact-SQL) ; ] ( ../../t-sql/queries/table-value-constructor-transact-sql.md ) | FROM, INSERT, MERGE|
46- | [ TOP ( ; Transact-SQL) ; ] ( ../../t-sql/queries/top-transact-sql.md ) | DELETE, INSERT, MERGE, SELECT, UPDATE|
47- | [ WHERE ( ; Transact-SQL) ; ] ( ../../t-sql/queries/where-transact-sql.md ) | DELETE, SELECT, UPDATE|
48- | [ WITH common_table_expression ( ; Transact-SQL) ; ] ( ../../t-sql/queries/with-common-table-expression-transact-sql.md ) | DELETE, INSERT, MERGE, SELECT, UPDATE|
49-
50-
22+ Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in [ !INCLUDE[ ssCurrent] ( ../../includes/sscurrent-md.md )] . Use these statements to add, modify, query, or remove data from a [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] database.
23+
24+ ## In This Section
25+ The following table lists the DML statements that [ !INCLUDE[ ssNoVersion] ( ../../includes/ssnoversion-md.md )] uses.
26+
27+ |||
28+ | -| -|
29+ | [ BULK INSERT ( ; Transact-SQL) ; ] ( ../../t-sql/statements/bulk-insert-transact-sql.md ) | [ SELECT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/select-transact-sql.md ) |
30+ | [ DELETE ( ; Transact-SQL) ; ] ( ../../t-sql/statements/delete-transact-sql.md ) | [ UPDATE ( ; Transact-SQL) ; ] ( ../../t-sql/queries/update-transact-sql.md ) |
31+ | [ INSERT ( ; Transact-SQL) ; ] ( ../../t-sql/statements/insert-transact-sql.md ) | [ UPDATETEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/updatetext-transact-sql.md ) |
32+ | [ MERGE ( ; Transact-SQL) ; ] ( ../../t-sql/statements/merge-transact-sql.md ) | [ WRITETEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/writetext-transact-sql.md ) |
33+ | [ READTEXT ( ; Transact-SQL) ; ] ( ../../t-sql/queries/readtext-transact-sql.md ) ||
34+
35+ The following table lists the clauses that are used in multiple DML statements or clauses.
36+
37+ | Clause| Can be used in these statements|
38+ | ------------| -------------------------------------|
39+ | [ FROM ( ; Transact-SQL) ; ] ( ../../t-sql/queries/from-transact-sql.md ) | DELETE, SELECT, UPDATE|
40+ | [ Hints ( ; Transact-SQL) ; ] ( ../../t-sql/queries/hints-transact-sql.md ) | DELETE, INSERT, SELECT, UPDATE|
41+ | [ OPTION Clause ( ; Transact-SQL) ; ] ( ../../t-sql/queries/option-clause-transact-sql.md ) | DELETE, SELECT, UPDATE|
42+ | [ OUTPUT Clause ( ; Transact-SQL) ; ] ( ../../t-sql/queries/output-clause-transact-sql.md ) | DELETE, INSERT, MERGE, UPDATE|
43+ | [ Search Condition ( ; Transact-SQL) ; ] ( ../../t-sql/queries/search-condition-transact-sql.md ) | DELETE, MERGE, SELECT, UPDATE|
44+ | [ Table Value Constructor ( ; Transact-SQL) ; ] ( ../../t-sql/queries/table-value-constructor-transact-sql.md ) | FROM, INSERT, MERGE|
45+ | [ TOP ( ; Transact-SQL) ; ] ( ../../t-sql/queries/top-transact-sql.md ) | DELETE, INSERT, MERGE, SELECT, UPDATE|
46+ | [ WHERE ( ; Transact-SQL) ; ] ( ../../t-sql/queries/where-transact-sql.md ) | DELETE, SELECT, UPDATE|
47+ | [ WITH common_table_expression ( ; Transact-SQL) ; ] ( ../../t-sql/queries/with-common-table-expression-transact-sql.md ) | DELETE, INSERT, MERGE, SELECT, UPDATE|
48+
49+
0 commit comments