Skip to content

Commit 918cdd8

Browse files
markingmynamemarkingmyname
committed
[Versioning] T-SQL/XML folder batch MicrosoftDocs#1 
1 parent 2a63673 commit 918cdd8

16 files changed

Lines changed: 203 additions & 26 deletions

‎docs/t-sql/statements/output.txt‎

Lines changed: 155 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,155 @@
1+
create-service-transact-sql.md
2+
create-spatial-index-transact-sql.md
3+
create-statistics-transact-sql.md
4+
create-symmetric-key-transact-sql.md
5+
create-synonym-transact-sql.md
6+
create-table-sql-graph.md
7+
create-table-transact-sql.md
8+
create-trigger-transact-sql.md
9+
create-type-transact-sql.md
10+
create-user-transact-sql.md
11+
create-view-transact-sql.md
12+
create-xml-index-transact-sql.md
13+
create-xml-schema-collection-transact-sql.md
14+
delete-transact-sql.md
15+
deny-assembly-permissions-transact-sql.md
16+
deny-asymmetric-key-permissions-transact-sql.md
17+
deny-availability-group-permissions-transact-sql.md
18+
deny-certificate-permissions-transact-sql.md
19+
deny-database-permissions-transact-sql.md
20+
deny-database-principal-permissions-transact-sql.md
21+
deny-database-scoped-credential-transact-sql.md
22+
deny-endpoint-permissions-transact-sql.md
23+
deny-full-text-permissions-transact-sql.md
24+
deny-object-permissions-transact-sql.md
25+
deny-schema-permissions-transact-sql.md
26+
deny-server-permissions-transact-sql.md
27+
deny-server-principal-permissions-transact-sql.md
28+
deny-service-broker-permissions-transact-sql.md
29+
deny-symmetric-key-permissions-transact-sql.md
30+
deny-system-object-permissions-transact-sql.md
31+
deny-transact-sql.md
32+
deny-type-permissions-transact-sql.md
33+
deny-xml-schema-collection-permissions-transact-sql.md
34+
disable-trigger-transact-sql.md
35+
drop-aggregate-transact-sql.md
36+
drop-application-role-transact-sql.md
37+
drop-assembly-transact-sql.md
38+
drop-asymmetric-key-transact-sql.md
39+
drop-availability-group-transact-sql.md
40+
drop-broker-priority-transact-sql.md
41+
drop-certificate-transact-sql.md
42+
drop-column-encryption-key-transact-sql.md
43+
drop-column-master-key-transact-sql.md
44+
drop-contract-transact-sql.md
45+
drop-credential-transact-sql.md
46+
drop-cryptographic-provider-transact-sql.md
47+
drop-database-audit-specification-transact-sql.md
48+
drop-default-transact-sql.md
49+
drop-endpoint-transact-sql.md
50+
drop-event-notification-transact-sql.md
51+
drop-event-session-transact-sql.md
52+
drop-external-resource-pool-transact-sql.md
53+
drop-fulltext-catalog-transact-sql.md
54+
drop-fulltext-index-transact-sql.md
55+
drop-fulltext-stoplist-transact-sql.md
56+
drop-index-transact-sql.md
57+
drop-login-transact-sql.md
58+
drop-message-type-transact-sql.md
59+
drop-partition-function-transact-sql.md
60+
drop-partition-scheme-transact-sql.md
61+
drop-procedure-transact-sql.md
62+
drop-queue-transact-sql.md
63+
drop-remote-service-binding-transact-sql.md
64+
drop-resource-pool-transact-sql.md
65+
drop-route-transact-sql.md
66+
drop-rule-transact-sql.md
67+
drop-schema-transact-sql.md
68+
drop-search-property-list-transact-sql.md
69+
drop-security-policy-transact-sql.md
70+
drop-sequence-transact-sql.md
71+
drop-server-audit-specification-transact-sql.md
72+
drop-service-transact-sql.md
73+
drop-signature-transact-sql.md
74+
drop-statistics-transact-sql.md
75+
drop-symmetric-key-transact-sql.md
76+
drop-synonym-transact-sql.md
77+
drop-table-transact-sql.md
78+
drop-trigger-transact-sql.md
79+
drop-type-transact-sql.md
80+
drop-user-transact-sql.md
81+
drop-view-transact-sql.md
82+
drop-xml-schema-collection-transact-sql.md
83+
enable-trigger-transact-sql.md
84+
end-conversation-transact-sql.md
85+
execute-as-clause-transact-sql.md
86+
get-conversation-group-transact-sql.md
87+
get-transmission-status-transact-sql.md
88+
grant-assembly-permissions-transact-sql.md
89+
grant-asymmetric-key-permissions-transact-sql.md
90+
grant-availability-group-permissions-transact-sql.md
91+
grant-certificate-permissions-transact-sql.md
92+
grant-database-permissions-transact-sql.md
93+
grant-database-principal-permissions-transact-sql.md
94+
grant-database-scoped-credential-transact-sql.md
95+
grant-endpoint-permissions-transact-sql.md
96+
grant-full-text-permissions-transact-sql.md
97+
grant-object-permissions-transact-sql.md
98+
grant-schema-permissions-transact-sql.md
99+
grant-server-permissions-transact-sql.md
100+
grant-server-principal-permissions-transact-sql.md
101+
grant-service-broker-permissions-transact-sql.md
102+
grant-symmetric-key-permissions-transact-sql.md
103+
grant-system-object-permissions-transact-sql.md
104+
grant-transact-sql.md
105+
grant-type-permissions-transact-sql.md
106+
grant-xml-schema-collection-permissions-transact-sql.md
107+
insert-sql-graph.md
108+
insert-transact-sql.md
109+
merge-transact-sql.md
110+
move-conversation-transact-sql.md
111+
open-master-key-transact-sql.md
112+
open-symmetric-key-transact-sql.md
113+
receive-transact-sql.md
114+
restore-master-key-transact-sql.md
115+
restore-service-master-key-transact-sql.md
116+
restore-statements-arguments-transact-sql.md
117+
restore-statements-rewindonly-transact-sql.md
118+
revert-transact-sql.md
119+
revoke-assembly-permissions-transact-sql.md
120+
revoke-asymmetric-key-permissions-transact-sql.md
121+
revoke-availability-group-permissions-transact-sql.md
122+
revoke-certificate-permissions-transact-sql.md
123+
revoke-database-permissions-transact-sql.md
124+
revoke-database-principal-permissions-transact-sql.md
125+
revoke-database-scoped-credential-transact-sql.md
126+
revoke-endpoint-permissions-transact-sql.md
127+
revoke-full-text-permissions-transact-sql.md
128+
revoke-object-permissions-transact-sql.md
129+
revoke-schema-permissions-transact-sql.md
130+
revoke-search-property-list-permissions-transact-sql.md
131+
revoke-server-permissions-transact-sql.md
132+
revoke-server-principal-permissions-transact-sql.md
133+
revoke-service-broker-permissions-transact-sql.md
134+
revoke-symmetric-key-permissions-transact-sql.md
135+
revoke-system-object-permissions-transact-sql.md
136+
revoke-transact-sql.md
137+
revoke-type-permissions-transact-sql.md
138+
revoke-xml-schema-collection-permissions-transact-sql.md
139+
send-transact-sql.md
140+
set-context-info-transact-sql.md
141+
set-datefirst-transact-sql.md
142+
set-dateformat-transact-sql.md
143+
set-fips-flagger-transact-sql.md
144+
set-lock-timeout-transact-sql.md
145+
set-offsets-transact-sql.md
146+
set-query-governor-cost-limit-transact-sql.md
147+
set-remote-proc-transactions-transact-sql.md
148+
set-rowcount-transact-sql.md
149+
set-textsize-transact-sql.md
150+
set-transaction-isolation-level-transact-sql.md
151+
setuser-transact-sql.md
152+
sql-server-collation-name-transact-sql.md
153+
truncate-table-transact-sql.md
154+
update-statistics-transact-sql.md
155+
windows-collation-name-transact-sql.md

‎docs/t-sql/xml/binding-relational-data-inside-xml-data.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "Binding Relational Data Inside XML Data | Microsoft Docs"
2+
title: Binding Relational Data Inside XML Data
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql

‎docs/t-sql/xml/delete-xml-dml.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "delete (XML DML) | Microsoft Docs"
2+
title: delete (XML DML)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -29,7 +29,9 @@ ms.author: genemi
2929
delete Expression
3030
```
3131

32-
## Arguments
32+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
33+
34+
## Arguments
3335
*Expression*
3436
Is an XQuery expression identifying the nodes to be deleted. All the nodes selected by the expression, and also all the nodes or values that are contained within the selected nodes, are deleted. As described in [insert (XML DML)](../../t-sql/xml/insert-xml-dml.md), this must be a reference to an existing node in the document. It cannot be a constructed node. The expression cannot be the root (/) node. If the expression returns an empty sequence, no deletion occurs and no errors are returned.
3537

‎docs/t-sql/xml/exist-method-xml-data-type.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "exist() Method (xml Data Type) | Microsoft Docs"
2+
title: exist() Method (xml Data Type)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -33,7 +33,9 @@ ms.author: genemi
3333
exist (XQuery)
3434
```
3535

36-
## Arguments
36+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
37+
38+
## Arguments
3739
XQuery
3840
Is an XQuery expression, a string literal.
3941

‎docs/t-sql/xml/guidelines-for-using-xml-data-type-methods.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "Guidelines for Using xml Data Type Methods | Microsoft Docs"
2+
title: Guidelines for Using xml Data Type Methods
33
ms.custom: ""
44
ms.date: "03/04/2017"
55
ms.prod: sql

‎docs/t-sql/xml/insert-xml-dml.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "insert (XML DML) | Microsoft Docs"
2+
title: insert (XML DML)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -33,7 +33,9 @@ insert
3333
)
3434
```
3535

36-
## Arguments
36+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
37+
38+
## Arguments
3739
*Expression1*
3840
Identifies one or more nodes to insert. This can be a constant XML instance; a reference to a typed XML data type instance of the same XML Schema collection on which the modify method is being applied; an untyped XML data type instance using a stand-alone **sql:column()**/**sql:variable()** function; or an XQuery expression. The expression can result in a node, and also a text node, or in an ordered sequence of nodes. It cannot resolve to the root (/) node. If the expression results in a value or a sequence of values, the values are inserted as a single text node with a space separating each value in the sequence. If you specify multiple nodes as constant, the nodes are included in parentheses and are separated by commas. You cannot insert heterogeneous sequences such as a sequence of elements, attributes, or values. If *Expression1* resolves to an empty sequence, no insertion occurs and no errors are returned.
3941

‎docs/t-sql/xml/modify-method-xml-data-type.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "modify() Method (xml Data Type) | Microsoft Docs"
2+
title: modify() Method (xml Data Type)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -27,7 +27,9 @@ ms.author: genemi
2727
modify (XML_DML)
2828
```
2929

30-
## Arguments
30+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
31+
32+
## Arguments
3133
XML_DML
3234
Is a string in XML Data Manipulation Language (DML). The XML document is updated according to this expression.
3335

‎docs/t-sql/xml/nodes-method-xml-data-type.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "nodes() Method (xml Data Type) | Microsoft Docs"
2+
title: nodes() Method (xml Data Type)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -33,7 +33,9 @@ You can retrieve multiple values from the rowset. For example, you can apply the
3333
nodes (XQuery) as Table(Column)
3434
```
3535

36-
## Arguments
36+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
37+
38+
## Arguments
3739
*XQuery*
3840
Is a string literal, an XQuery expression. If the query expression constructs nodes, these constructed nodes are exposed in the resulting rowset. If the query expression results in an empty sequence, the rowset is empty as well. If the query expression statically results in a sequence that contains atomic values instead of nodes, a static error is raised.
3941

‎docs/t-sql/xml/query-method-xml-data-type.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "query() Method (xml Data Type) | Microsoft Docs"
2+
title: query() Method (xml Data Type)
33
ms.custom: ""
44
ms.date: 04/16/2020
55
ms.prod: sql
@@ -27,7 +27,9 @@ Specifies an XQuery against an instance of the **xml** data type. The result is
2727
query ('XQuery')
2828
```
2929

30-
## Arguments
30+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
31+
32+
## Arguments
3133
XQuery
3234
Is a string, an XQuery expression, that queries for XML nodes, such as elements and attributes, in an XML instance.
3335

‎docs/t-sql/xml/replace-value-of-xml-dml.md‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
---
2-
title: "replace value of (XML DML) | Microsoft Docs"
2+
title: replace value of (XML DML)
33
ms.custom: ""
44
ms.date: "07/26/2017"
55
ms.prod: sql
@@ -30,7 +30,9 @@ replace value of Expression1
3030
with Expression2
3131
```
3232

33-
## Arguments
33+
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
34+
35+
## Arguments
3436
*Expression1*
3537
Identifies a node whose value is to be updated. It must identify only a single node. That is, *Expression1* must be a static singleton. If the XML is typed, the type of the node must be a simple type. When multiple nodes are selected, an error is raised. If *Expression1* returns an empty sequence, no value replacement occurs and no errors are returned. *Expression1* must return a single element that has simple type content (list or atomic types), a text node, or an attribute node. *Expression1* can't be a union type, a complex type, a processing instruction, a document node, or a comment node, or an error is returned.
3638

0 commit comments

Comments
 (0)