Adding descriptions to top page view T-SQL

rothja · rothja · commit 824cb3236683 · 2020-03-30T14:30:07.000-04:00
diff --git a/docs/t-sql/data-types/data-types-transact-sql.md b/docs/t-sql/data-types/data-types-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "Data types (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.custom: "This article provides a summary of the different data types available in SQL Server."
 ms.date: "09/13/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/data-types/decimal-and-numeric-transact-sql.md b/docs/t-sql/data-types/decimal-and-numeric-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "decimal and numeric (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the decimal and numeric data types. Decimal and numeric are synonyms for numeric data types that have a fixed precision and scale."
 ms.date: "09/10/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql.md b/docs/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "int, bigint, smallint, and tinyint (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for int, bigint, smallint, and tinyint data types. These data types are used to represent integer data."
 ms.date: 09/08/2017
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/cast-and-convert-transact-sql.md b/docs/t-sql/functions/cast-and-convert-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "CAST and CONVERT (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another."
 ms.date: "08/23/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/charindex-transact-sql.md b/docs/t-sql/functions/charindex-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "CHARINDEX (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the CHARINDEX function."
 ms.date: "07/24/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/dateadd-transact-sql.md b/docs/t-sql/functions/dateadd-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "DATEADD (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the DATEADD function. This function returns a date that has been modified by the specified date part."
 ms.date: "07/29/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/datediff-transact-sql.md b/docs/t-sql/functions/datediff-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "DATEDIFF (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the DATEDIFF function. Returns the numerical difference between a start and end date based on datepart."
 ms.date: "07/18/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/datepart-transact-sql.md b/docs/t-sql/functions/datepart-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "DATEPART (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the DATEPART function. This function returns an integer corresponding to the datepart of a specified date."
 ms.date: "07/29/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/format-transact-sql.md b/docs/t-sql/functions/format-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "FORMAT (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the FORMAT function."
 ms.date: "08/15/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
@@ -184,11 +184,11 @@ ORDER BY CurrencyRateID;
 ```
 CurrencyRateID EndOfDayRate  Numeric Format  General Format  Currency Format  
 -------------- ------------  --------------  --------------  ---------------  
-1              1.0002        1,00            1,0002          1,00 €  
-2              1.55          1,55            1,5500          1,55 €  
-3              1.9419        1,94            1,9419          1,94 €  
-4              1.4683        1,47            1,4683          1,47 €  
-5              8.2784        8,28            8,2784          8,28 €  
+1              1.0002        1,00            1,0002          1,00 &euro;  
+2              1.55          1,55            1,5500          1,55 &euro;  
+3              1.9419        1,94            1,9419          1,94 &euro;  
+4              1.4683        1,47            1,4683          1,47 &euro;  
+5              8.2784        8,28            8,2784          8,28 &euro;  
   
  (5 row(s) affected)  
 ```  
diff --git a/docs/t-sql/functions/getdate-transact-sql.md b/docs/t-sql/functions/getdate-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "GETDATE (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the GETDATE function, which returns the current database system time as a datetime value."
 ms.date: "09/07/2018"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/replace-transact-sql.md b/docs/t-sql/functions/replace-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "REPLACE (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the REPLACE function, which replaces all occurrences of a specified string value with another string value."
 ms.date: "08/23/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/row-number-transact-sql.md b/docs/t-sql/functions/row-number-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "ROW_NUMBER (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the ROW_NUMBER function. This function numbers the output of a result set."
 ms.date: "09/11/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/functions/string-split-transact-sql.md b/docs/t-sql/functions/string-split-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "STRING_SPLIT (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the STRING_SPLIT function. This table-valued function splits a string into substrings based on a character delimiter."
 ms.date: "11/28/2018"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/functions/substring-transact-sql.md b/docs/t-sql/functions/substring-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "SUBSTRING (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the SUBSTRING function. This function returns a portion of a specified character, binary, text, or image expression."
 ms.date: "10/21/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
@@ -81,10 +81,10 @@ WHERE database_id < 5;
 
 |name |Initial |ThirdAndFourthCharacters|
 |---|--|--|
-|master	 |m	 |st |
-|tempdb	 |t	 |mp |
-|model	 |m	 |de |
-|msdb	 |m	 |db |
+|master    |m    |st |
+|tempdb    |t    |mp |
+|model    |m    |de |
+|msdb    |m    |db |
 
 
   
diff --git a/docs/t-sql/language-elements/case-transact-sql.md b/docs/t-sql/language-elements/case-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "CASE (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the CASE expression. CASE evaluates a list of conditions to return specific results."
 ms.date: "06/28/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/language-elements/coalesce-transact-sql.md b/docs/t-sql/language-elements/coalesce-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "COALESCE (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for COALESCE, which returns the value of the first expression that does not evaluate to NULL."
 ms.date: "08/30/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/language-elements/declare-local-variable-transact-sql.md b/docs/t-sql/language-elements/declare-local-variable-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "DECLARE @local_variable (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for using DECLARE to define local variables for use in a batch or procedure."
 ms.date: "07/24/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/language-elements/if-else-transact-sql.md b/docs/t-sql/language-elements/if-else-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "IF...ELSE (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQl language reference for IF-ELSE statements to provide control flow in Transact-SQL statements."
 ms.date: "07/11/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/queries/contains-transact-sql.md b/docs/t-sql/queries/contains-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "CONTAINS (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the CONTAINS language element. Used to search for words or phrases within another expression."
 ms.date: "08/23/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/queries/from-using-pivot-and-unpivot.md b/docs/t-sql/queries/from-using-pivot-and-unpivot.md
@@ -1,6 +1,6 @@
 ---
 title: "Using PIVOT and UNPIVOT | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for PIVOT and UNPIVOT relational operators. Use these operators on SELECT statements to change a table-valued expression into another table."
 ms.date: "10/14/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/queries/select-over-clause-transact-sql.md b/docs/t-sql/queries/select-over-clause-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "OVER Clause (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the OVER clause, which defines a user-specified set of rows within a query result set."
 ms.date: "08/11/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
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
@@ -1,6 +1,6 @@
 ---
 title: "WITH common_table_expression (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for how to use common table expressions (CTE) in queries."
 ms.date: "08/09/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/statements/bulk-insert-transact-sql.md b/docs/t-sql/statements/bulk-insert-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "BULK INSERT (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the BULK INSERT statement."
 ms.date: 02/21/2020
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/create-trigger-transact-sql.md b/docs/t-sql/statements/create-trigger-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "CREATE TRIGGER (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the CREATE TRIGGER statement, which is used to create a DML, DDL, or logon trigger."
 ms.date: "10/30/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/set-identity-insert-transact-sql.md b/docs/t-sql/statements/set-identity-insert-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "SET IDENTITY_INSERT (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+ms.description: "Transact-SQL reference for the SET IDENTITY_INSERT statement. When set to ON, this permits inserting explicit values into the identity column of a table."
 ms.date: "06/10/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
