[Versioning] T-SQL/Queries folder batch MicrosoftDocs#1

markingmyname · markingmyname · commit 2b8e794cf5b9 · 2020-07-20T10:39:12.000-05:00
diff --git a/docs/t-sql/queries/contains-transact-sql.md b/docs/t-sql/queries/contains-transact-sql.md
@@ -134,7 +134,9 @@ CONTAINS (
   
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *column_name*  
  Is the name of a full-text indexed column of the table specified in the FROM clause. The columns can be of type **char**, **varchar**, **nchar**, **nvarchar**, **text**, **ntext**, **image**, **xml**, **varbinary**, or **varbinary(max)**.  
   
diff --git a/docs/t-sql/queries/freetext-transact-sql.md b/docs/t-sql/queries/freetext-transact-sql.md
@@ -48,7 +48,9 @@ FREETEXT ( { column_name | (column_list) | * }
           , 'freetext_string' [ , LANGUAGE language_term ] )  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *column_name*  
  Is the name of one or more full-text indexed columns of the table specified in the FROM clause. The columns can be of type **char**, **varchar**, **nchar**, **nvarchar**, **text**, **ntext**, **image**, **xml**, **varbinary**, or **varbinary(max)**.  
   
diff --git a/docs/t-sql/queries/hints-transact-sql-join.md b/docs/t-sql/queries/hints-transact-sql-join.md
@@ -49,7 +49,9 @@ ms.author: vanto
      { LOOP | HASH | MERGE | REMOTE }  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  LOOP | HASH | MERGE  
  Specifies that the join in the query should use looping, hashing, or merging. Using LOOP |HASH | MERGE JOIN enforces a particular join between two tables. LOOP cannot be specified together with RIGHT or FULL as a join type. For more information, see [Joins](../../relational-databases/performance/joins.md).
   
diff --git a/docs/t-sql/queries/hints-transact-sql-query.md b/docs/t-sql/queries/hints-transact-sql-query.md
@@ -132,7 +132,9 @@ Query hints specify that the indicated hints should be used throughout the query
 }  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 { HASH | ORDER } GROUP  
 Specifies that aggregations that the query's GROUP BY or DISTINCT clause describes should use hashing or ordering.  
   
diff --git a/docs/t-sql/queries/hints-transact-sql-table.md b/docs/t-sql/queries/hints-transact-sql-table.md
@@ -114,7 +114,9 @@ WITH  ( <table_hint> [ [, ]...n ] )
 }   
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 WITH **(** \<table_hint> **)** [ [**,** ]...*n* ]  
 With some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH keyword. Table hints also must be specified with parentheses.  
   
diff --git a/docs/t-sql/queries/is-null-transact-sql.md b/docs/t-sql/queries/is-null-transact-sql.md
@@ -46,7 +46,9 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 expression IS [ NOT ] NULL  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *expression*  
  Is any valid [expression](../../t-sql/language-elements/expressions-transact-sql.md).  
   
diff --git a/docs/t-sql/queries/match-sql-graph.md b/docs/t-sql/queries/match-sql-graph.md
@@ -107,7 +107,9 @@ n -  positive integer only.
  
 ```
 
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 *graph_search_pattern*  
 Specifies the pattern to search or path to traverse in the graph. This pattern uses ASCII art syntax to traverse a path in the graph. The pattern goes from one node to another via an edge, in the direction of the arrow provided. Edge names or aliases are provided inside parentheses. Node names or aliases appear at the two ends of the arrow. The arrow can go in either direction in the pattern.
 
diff --git a/docs/t-sql/queries/option-clause-transact-sql.md b/docs/t-sql/queries/option-clause-transact-sql.md
@@ -56,7 +56,9 @@ OPTION ( <query_option> [ ,...n ] )
     | { FORCE | DISABLE } EXTERNALPUSHDOWN  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *query_hint*  
  Keywords that indicate which optimizer hints are used to customize the way the Database Engine processes the statement. For more information, see [Query Hints &#40;Transact-SQL&#41;](../../t-sql/queries/hints-transact-sql-query.md).  
   
diff --git a/docs/t-sql/queries/output-clause-transact-sql.md b/docs/t-sql/queries/output-clause-transact-sql.md
@@ -69,7 +69,9 @@ ms.author: vanto
     | $action  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  \@*table_variable*  
  Specifies a **table** variable that the returned rows are inserted into instead of being returned to the caller. \@*table_variable* must be declared before the INSERT, UPDATE, DELETE, or MERGE statement.  
   
diff --git a/docs/t-sql/queries/readtext-transact-sql.md b/docs/t-sql/queries/readtext-transact-sql.md
@@ -37,7 +37,9 @@ Reads **text**, **ntext**, or **image** values from a **text**, **ntext**, or **
 READTEXT { table.column text_ptr offset size } [ HOLDLOCK ]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 _table_ **.** _column_  
 Is the name of a table and column from which to read. Table and column names must fulfill the rules for [identifiers](../../relational-databases/databases/database-identifiers.md). Specifying the table and column names is required; however, specifying the database name and owner names is optional.  
   
diff --git a/docs/t-sql/queries/search-condition-transact-sql.md b/docs/t-sql/queries/search-condition-transact-sql.md
@@ -104,7 +104,9 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
     | expression [ NOT ] EXISTS (subquery)     }   
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  \<search_condition>  
  Specifies the conditions for the rows returned in the result set for a SELECT statement, query expression, or subquery. For an UPDATE statement, specifies the rows to be updated. For a DELETE statement, specifies the rows to be deleted. There is no limit to the number of predicates that can be included in a [!INCLUDE[tsql](../../includes/tsql-md.md)] statement search condition.  
   
diff --git a/docs/t-sql/queries/select-clause-transact-sql.md b/docs/t-sql/queries/select-clause-transact-sql.md
@@ -57,7 +57,9 @@ SELECT [ ALL | DISTINCT ]
     } [ ,...n ]   
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  **ALL**  
  Specifies that duplicate rows can appear in the result set. ALL is the default.  
   
diff --git a/docs/t-sql/queries/select-group-by-transact-sql.md b/docs/t-sql/queries/select-group-by-transact-sql.md
@@ -99,7 +99,9 @@ GROUP BY {
 
 ```  
     
-## Arguments 
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  
 ### *column-expression*  
 Specifies a column or a non-aggregate calculation on a column. This column can belong to a table, derived table, or view. The column must appear in the FROM clause of the SELECT statement, but is not required to appear in the SELECT list. 
diff --git a/docs/t-sql/queries/select-having-transact-sql.md b/docs/t-sql/queries/select-having-transact-sql.md
@@ -35,7 +35,9 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 [ HAVING <search condition> ]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 \<search_condition>
  Specifies one or more predicates for groups and/or aggregates to meet. For more information about search conditions and predicates, see [Search Condition &#40;Transact-SQL&#41;](../../t-sql/queries/search-condition-transact-sql.md).  
   
diff --git a/docs/t-sql/queries/select-into-clause-transact-sql.md b/docs/t-sql/queries/select-into-clause-transact-sql.md
@@ -44,7 +44,9 @@ SELECT...INTO creates a new table in the default filegroup and inserts the resul
 [ ON filegroup ]
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *new_table*   
  Specifies the name of a new table to be created, based on the columns in the select list and the rows chosen from the data source.  
  
diff --git a/docs/t-sql/queries/select-order-by-clause-transact-sql.md b/docs/t-sql/queries/select-order-by-clause-transact-sql.md
@@ -86,7 +86,9 @@ ORDER BY order_by_expression
 ]   
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *order_by_expression*  
  Specifies a column or expression on which to sort the query result set. A sort column can be specified as a name or column alias, or a nonnegative integer representing the position of the column in the select list.  
   
diff --git a/docs/t-sql/queries/select-over-clause-transact-sql.md b/docs/t-sql/queries/select-over-clause-transact-sql.md
@@ -101,7 +101,9 @@ ORDER BY order_by_expression
 OVER ( [ PARTITION BY value_expression ] [ order_by_clause ] )  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  PARTITION BY  
  Divides the query result set into partitions. The window function is applied to each partition separately and computation restarts for each partition.  
   
diff --git a/docs/t-sql/queries/table-value-constructor-transact-sql.md b/docs/t-sql/queries/table-value-constructor-transact-sql.md
@@ -38,7 +38,9 @@ VALUES ( <row value expression list> ) [ ,...n ]
     { DEFAULT | NULL | expression }  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  VALUES  
  Introduces the row value expression lists. Each list must be enclosed in parentheses and separated by a comma.  
   
diff --git a/docs/t-sql/queries/top-transact-sql.md b/docs/t-sql/queries/top-transact-sql.md
@@ -49,7 +49,9 @@ Following is syntax for Azure SQL Data Warehouse and Parallel Data Warehouse:
 ]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 *expression*  
 The numeric expression that specifies the number of rows to be returned. *expression* is implicitly converted to a **float** value if you specify PERCENT. Otherwise, *expression* is converted to **bigint**.  
   
diff --git a/docs/t-sql/queries/update-transact-sql.md b/docs/t-sql/queries/update-transact-sql.md
@@ -129,7 +129,9 @@ SET { column_name = { expression | NULL } } [ ,...n ]
 [;]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  WITH \<common_table_expression>  
  Specifies the temporary named result set or view, also known as common table expression (CTE), defined within the scope of the UPDATE statement. The CTE result set is derived from a simple query and is referenced by UPDATE statement.  
   
diff --git a/docs/t-sql/queries/updatetext-transact-sql.md b/docs/t-sql/queries/updatetext-transact-sql.md
@@ -43,7 +43,9 @@ UPDATETEXT [BULK] { table_name.dest_column_name dest_text_ptr }
     | { table_name.src_column_name src_text_ptr } ]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  BULK  
  Enables upload tools to upload a binary data stream. The stream must be provided by the tool at the TDS protocol level. When the data stream is not present the query processor ignores the BULK option.  
   
diff --git a/docs/t-sql/queries/where-transact-sql.md b/docs/t-sql/queries/where-transact-sql.md
@@ -36,7 +36,9 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 [ WHERE <search_condition> ]  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
 \< *search_condition* >
  Defines the condition to be met for the rows to be returned. There is no limit to the number of predicates that can be included in a search condition. For more information about search conditions and predicates, see [Search Condition &#40;Transact-SQL&#41;](../../t-sql/queries/search-condition-transact-sql.md).  
   
diff --git a/docs/t-sql/queries/with-common-table-expression-transact-sql.md b/docs/t-sql/queries/with-common-table-expression-transact-sql.md
@@ -46,7 +46,9 @@ Specifies a temporary named result set, known as a common table expression (CTE)
     ( CTE_query_definition )  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  *expression_name*  
 Is a valid identifier for the common table expression. *expression_name* must be different from the name of any other common table expression defined in the same WITH \<common_table_expression> clause, but *expression_name* can be the same as the name of a base table or view. Any reference to *expression_name* in the query uses the common table expression and not the base object.
   
diff --git a/docs/t-sql/queries/writetext-transact-sql.md b/docs/t-sql/queries/writetext-transact-sql.md
@@ -43,7 +43,9 @@ WRITETEXT [BULK]
   [ WITH LOG ] { data }  
 ```  
   
-## Arguments  
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
+## Arguments
  BULK  
  Enables upload tools to upload a binary data stream. The stream must be provided by the tool at the TDS protocol level. When the data stream is not present the query processor ignores the BULK option.  
   

Original file line number	Diff line number	Diff line change
`@@ -132,7 +132,9 @@ Query hints specify that the indicated hints should be used throughout the query`
`132`	`132`	`}`
`133`	`133`	```
`134`	`134`
`135`		`-## Arguments`
	`135`	`+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]`
	`136`	`+`
	`137`	`+## Arguments`
`136`	`138`	`{ HASH \| ORDER } GROUP`
`137`	`139`	`Specifies that aggregations that the query's GROUP BY or DISTINCT clause describes should use hashing or ordering.`
`138`	`140`
Original file line number	Diff line number	Diff line change
`@@ -114,7 +114,9 @@ WITH ( <table_hint> [ [, ]...n ] )`
`114`	`114`	`}`
`115`	`115`	```
`116`	`116`
`117`		`-## Arguments`
	`117`	`+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]`
	`118`	`+`
	`119`	`+## Arguments`
`118`	`120`	`WITH ( \<table_hint> ) [ [, ]...n ]`
`119`	`121`	`With some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH keyword. Table hints also must be specified with parentheses.`
`120`	`122`