update topic author meta

craigg-msft · craigg-msft · commit 9793a4c6cfdd · 2019-03-04T10:03:36.000-08:00
diff --git a/docs/t-sql/language-elements/checkpoint-transact-sql.md b/docs/t-sql/language-elements/checkpoint-transact-sql.md
@@ -24,8 +24,8 @@ helpviewer_keywords:
   - "manual checkpoints [SQL Server]"
   - "pages [SQL Server], checkpoints"
 ms.assetid: ccdfc689-ad4e-44c0-83f7-0f2cfcfb6406
-author: douglaslMS
-ms.author: douglasl
+author: juliemsft
+ms.author: jrasnick
 manager: craigg
 ---
 # CHECKPOINT (Transact-SQL)
diff --git a/docs/t-sql/language-elements/like-transact-sql.md b/docs/t-sql/language-elements/like-transact-sql.md
@@ -28,8 +28,8 @@ helpviewer_keywords:
   - "matching patterns [SQL Server]"
   - "NOT LIKE keyword"
 ms.assetid: 581fb289-29f9-412b-869c-18d33a9e93d5
-author: douglaslMS
-ms.author: douglasl
+author: juliemsft
+ms.author: jrasnick
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/at-time-zone-transact-sql.md b/docs/t-sql/queries/at-time-zone-transact-sql.md
@@ -13,8 +13,8 @@ f1_keywords:
 helpviewer_keywords: 
   - "AT TIME ZONE function"
 ms.assetid: 311f682f-7f1b-43b6-9ea0-24e36b64f73a
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # AT TIME ZONE (Transact-SQL)
diff --git a/docs/t-sql/queries/contains-transact-sql.md b/docs/t-sql/queries/contains-transact-sql.md
@@ -32,8 +32,8 @@ helpviewer_keywords:
   - "inflectional forms [full-text search]"
   - "prefix searches [full-text search]"
 ms.assetid: 996c72fc-b1ab-4c96-bd12-946be9c18f84
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # CONTAINS (Transact-SQL)
diff --git a/docs/t-sql/queries/freetext-transact-sql.md b/docs/t-sql/queries/freetext-transact-sql.md
@@ -19,8 +19,8 @@ helpviewer_keywords:
   - "words in predicate [full-text search]"
   - "column searches [full-text search]"
 ms.assetid: 2f199d3c-440e-4bcf-bdb5-82bb3994005d
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # FREETEXT (Transact-SQL)
diff --git a/docs/t-sql/queries/from-transact-sql.md b/docs/t-sql/queries/from-transact-sql.md
@@ -31,8 +31,8 @@ helpviewer_keywords:
   - "UPDATE statement [SQL Server], FROM clause"
   - "derived tables"
 ms.assetid: 36b19e68-94f6-4539-aeb1-79f5312e4263
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/from-using-pivot-and-unpivot.md b/docs/t-sql/queries/from-using-pivot-and-unpivot.md
@@ -21,8 +21,8 @@ helpviewer_keywords:
   - "FROM clause, PIVOT operator"
   - "rotating columns"
 ms.assetid: 24ba54fc-98f7-4d35-8881-b5158aac1d66
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/hints-transact-sql-join.md b/docs/t-sql/queries/hints-transact-sql-join.md
@@ -20,8 +20,8 @@ helpviewer_keywords:
   - "MERGE join hint"
   - "hints [SQL Server], join"
 ms.assetid: 09069f4a-f2e3-4717-80e1-c0110058efc4
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Hints (Transact-SQL) - Join
diff --git a/docs/t-sql/queries/hints-transact-sql-query.md b/docs/t-sql/queries/hints-transact-sql-query.md
@@ -53,8 +53,8 @@ helpviewer_keywords:
   - "USE HINT query hint"
   - "QUERY_PLAN_PROFILE query hint"
 ms.assetid: 66fb1520-dcdf-4aab-9ff1-7de8f79e5b2d
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Hints (Transact-SQL) - Query
diff --git a/docs/t-sql/queries/hints-transact-sql-table.md b/docs/t-sql/queries/hints-transact-sql-table.md
@@ -34,8 +34,8 @@ helpviewer_keywords:
   - "NOEXPAND table hint"
   - "PAGLOCK table hint"
 ms.assetid: 8bf1316f-c0ef-49d0-90a7-3946bc8e7a89
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Hints (Transact-SQL) - Table
diff --git a/docs/t-sql/queries/hints-transact-sql.md b/docs/t-sql/queries/hints-transact-sql.md
@@ -18,8 +18,8 @@ helpviewer_keywords:
   - "UPDATE statement [SQL Server], hints"
   - "DELETE statement [SQL Server], hints"
 ms.assetid: 99412475-b0df-4264-9938-33a0b302b41a
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Hints (Transact-SQL)
diff --git a/docs/t-sql/queries/is-null-transact-sql.md b/docs/t-sql/queries/is-null-transact-sql.md
@@ -29,8 +29,8 @@ helpviewer_keywords:
   - "testing nullability"
   - "checking nullability"
 ms.assetid: cdc45cd8-e9b6-4648-8417-892fbeab15af
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/option-clause-transact-sql.md b/docs/t-sql/queries/option-clause-transact-sql.md
@@ -18,8 +18,8 @@ helpviewer_keywords:
   - "clauses [SQL Server], OPTION"
   - "OPTION clause"
 ms.assetid: f47e2f3f-9302-4711-9d66-16b1a2a7ffe3
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/output-clause-transact-sql.md b/docs/t-sql/queries/output-clause-transact-sql.md
@@ -28,8 +28,8 @@ helpviewer_keywords:
   - "displaying deleted rows"
   - "UPDATE statement [SQL Server], OUTPUT clause"
 ms.assetid: 41b9962c-0c71-4227-80a0-08fdc19f5fe4
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # OUTPUT Clause (Transact-SQL)
diff --git a/docs/t-sql/queries/predicates.md b/docs/t-sql/queries/predicates.md
@@ -19,8 +19,8 @@ helpviewer_keywords:
   - "predicates [full-text search]"
   - "expressions [SQL Server], predicates"
 ms.assetid: ddbc530c-f44d-4551-9ca3-3430258eb6c0
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Predicates
diff --git a/docs/t-sql/queries/predict-transact-sql.md b/docs/t-sql/queries/predict-transact-sql.md
@@ -14,8 +14,8 @@ dev_langs:
   - "TSQL"
 helpviewer_keywords: 
   - "PREDICT clause"
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=sql-server-2017||=azuresqldb-current||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/queries.md b/docs/t-sql/queries/queries.md
@@ -10,8 +10,8 @@ ms.topic: "language-reference"
 dev_langs: 
   - "TSQL"
 ms.assetid: 5ff02a32-e8d3-479c-ae8b-07581e41f5f8
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto"
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/readtext-transact-sql.md b/docs/t-sql/queries/readtext-transact-sql.md
@@ -17,8 +17,8 @@ helpviewer_keywords:
   - "READTEXT statement"
   - "reading columns"
 ms.assetid: 91b69853-1381-4306-8343-afdb73105738
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # READTEXT (Transact-SQL)
diff --git a/docs/t-sql/queries/search-condition-transact-sql.md b/docs/t-sql/queries/search-condition-transact-sql.md
@@ -34,8 +34,8 @@ helpviewer_keywords:
   - "logical operators [SQL Server], precedence"
   - "LIKE comparisons"
 ms.assetid: 09974469-c5d2-4be8-bc5a-78e404660b2c
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/select-clause-transact-sql.md b/docs/t-sql/queries/select-clause-transact-sql.md
@@ -24,8 +24,8 @@ helpviewer_keywords:
   - "$ROWGUID keyword"
   - "queries [SQL Server], results"
 ms.assetid: 2616d800-4853-4cf1-af77-d32d68d8c2ef
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # SELECT Clause (Transact-SQL)
diff --git a/docs/t-sql/queries/select-examples-transact-sql.md b/docs/t-sql/queries/select-examples-transact-sql.md
@@ -28,8 +28,8 @@ helpviewer_keywords:
   - "computed sums"
   - "WHERE clause, SELECT statement"
 ms.assetid: 9b9caa3d-e7d0-42e1-b60b-a5572142186c
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # SELECT Examples (Transact-SQL)
diff --git a/docs/t-sql/queries/select-for-clause-transact-sql.md b/docs/t-sql/queries/select-for-clause-transact-sql.md
@@ -19,8 +19,8 @@ helpviewer_keywords:
   - "BROWSE option"
   - "FOR clause [Transact-SQL]"
 ms.assetid: 08a6f084-8f73-4f2a-bae4-3c7513dc99b9
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # SELECT - FOR Clause (Transact-SQL)
diff --git a/docs/t-sql/queries/select-having-transact-sql.md b/docs/t-sql/queries/select-having-transact-sql.md
@@ -18,8 +18,8 @@ helpviewer_keywords:
   - "HAVING clause"
   - "HAVING clause, about HAVING clause"
 ms.assetid: 55650709-001e-42f4-902f-ead09a3c34af
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/select-into-clause-transact-sql.md b/docs/t-sql/queries/select-into-clause-transact-sql.md
@@ -26,8 +26,8 @@ helpviewer_keywords:
   - "clauses [SQL Server], INTO"
   - "row additions [SQL Server], INTO clause"
 ms.assetid: b48d69e8-5a00-48bf-b2f3-19278a72dd88
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
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
@@ -36,8 +36,8 @@ helpviewer_keywords:
   - "sort orders [SQL Server], ORDER BY clause"
   - "FETCH clause"
 ms.assetid: bb394abe-cae6-4905-b5c6-8daaded77742
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/select-over-clause-transact-sql.md b/docs/t-sql/queries/select-over-clause-transact-sql.md
@@ -22,8 +22,8 @@ helpviewer_keywords:
   - "rowsets [SQL Server], ordering"
   - "OVER clause"
 ms.assetid: ddcef3a6-0341-43e0-ae73-630484b7b398
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/select-transact-sql.md b/docs/t-sql/queries/select-transact-sql.md
@@ -22,8 +22,8 @@ helpviewer_keywords:
   - "row retrieval [SQL Server]"
   - "queries [SQL Server], results"
 ms.assetid: dc85caea-54d1-49af-b166-f3aa2f3a93d0
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/table-value-constructor-transact-sql.md b/docs/t-sql/queries/table-value-constructor-transact-sql.md
@@ -15,8 +15,8 @@ helpviewer_keywords:
   - "row constructor [SQL Server]"
   - "table value constructor [SQL Server]"
 ms.assetid: e57cd31d-140e-422f-8178-2761c27b9deb
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # Table Value Constructor (Transact-SQL)
diff --git a/docs/t-sql/queries/top-transact-sql.md b/docs/t-sql/queries/top-transact-sql.md
@@ -18,8 +18,8 @@ helpviewer_keywords:
   - "TOP clause, about TOP clause"
   - "queries [SQL Server], results"
 ms.assetid: da983c0a-06c5-4cf8-a6a4-7f9d66f34f2c
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/update-transact-sql.md b/docs/t-sql/queries/update-transact-sql.md
@@ -35,8 +35,8 @@ helpviewer_keywords:
   - "FROM clause, UPDATE statement"
   - "WHERE clause, UPDATE statement"
 ms.assetid: 40e63302-0c68-4593-af3e-6d190181fee7
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/updatetext-transact-sql.md b/docs/t-sql/queries/updatetext-transact-sql.md
@@ -18,16 +18,16 @@ helpviewer_keywords:
   - "data updates [SQL Server], UPDATETEXT statement"
   - "UPDATETEXT statement"
 ms.assetid: d73c28ee-3972-4afd-af8d-ebbbd9e50793
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # UPDATETEXT (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]
 
   Updates an existing **text**, **ntext**, or **image** field. Use UPDATETEXT to change only a part of a **text**, **ntext**, or **image** column in place. Use WRITETEXT to update and replace a whole **text**, **ntext**, or **image** field.  
   
-> [!IMPORTANT]
+> [!IMPORTANT]
 >  [!INCLUDE[ssNoteDepFutureAvoid](../../includes/ssnotedepfutureavoid-md.md)] Use the large-value data types and the **.**WRITE clause of the [UPDATE](../../t-sql/queries/update-transact-sql.md) statement instead.  
   
  ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
diff --git a/docs/t-sql/queries/where-transact-sql.md b/docs/t-sql/queries/where-transact-sql.md
@@ -19,8 +19,8 @@ helpviewer_keywords:
   - "row retrieval [SQL Server], WHERE clause"
   - "WHERE clause"
 ms.assetid: a8430421-7bce-4fab-a2d2-56c00a3c6fa4
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
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
@@ -24,8 +24,8 @@ helpviewer_keywords:
   - "MAXRECURSION hint"
   - "clauses [SQL Server], WITH common_table_expression"
 ms.assetid: 27cfb819-3e8d-4274-8bbe-cbbe4d9c2e23
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
diff --git a/docs/t-sql/queries/writetext-transact-sql.md b/docs/t-sql/queries/writetext-transact-sql.md
@@ -21,16 +21,16 @@ helpviewer_keywords:
   - "overwriting data"
   - "data updates [SQL Server], WRITETEXT statement"
 ms.assetid: 80c252fd-a8b8-4a2e-888a-059081ed4109
-author: "douglaslMS"
-ms.author: "douglasl"
+author: VanMSFT
+ms.author: vanto
 manager: craigg
 ---
 # WRITETEXT (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]
 
   Permits minimally logged, interactive updating of an existing **text**, **ntext**, or **image** column. WRITETEXT overwrites any existing data in the column it affects. WRITETEXT cannot be used on **text**, **ntext**, and **image** columns in views.  
   
-> [!IMPORTANT]
+> [!IMPORTANT]
 >  [!INCLUDE[ssNoteDepFutureAvoid](../../includes/ssnotedepfutureavoid-md.md)] Use the large-value data types and the **.**WRITE clause of the [UPDATE](../../t-sql/queries/update-transact-sql.md) statement instead.  
   
  ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
