removed some erroneous entries

markingmyname · markingmyname · commit a0bdee2cdfd5 · 2020-07-19T23:29:12.000-05:00
diff --git a/docs/t-sql/data-types/binary-and-varbinary-transact-sql.md b/docs/t-sql/data-types/binary-and-varbinary-transact-sql.md
@@ -22,14 +22,15 @@ author: MikeRayMSFT
 ms.author: mikeray
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
+
 # binary and varbinary (Transact-SQL)
+
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 Binary data types of either fixed length or variable length.
   
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
-
 ## Arguments
+
 **binary** [ ( _n_ ) ]
 Fixed-length binary data with a length of _n_ bytes, where _n_ is a value from 1 through 8,000. The storage size is _n_ bytes.
   
diff --git a/docs/t-sql/data-types/char-and-varchar-transact-sql.md b/docs/t-sql/data-types/char-and-varchar-transact-sql.md
@@ -1,5 +1,5 @@
 ---
-title: "char and varchar (Transact-SQL) | Microsoft Docs"
+title: char and varchar (Transact-SQL)
 ms.custom: ""
 ms.date: "11/19/2019"
 ms.prod: sql
@@ -25,14 +25,13 @@ author: MikeRayMSFT
 ms.author: mikeray
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
+
 # char and varchar (Transact-SQL)
 
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 Character data types that are either fixed-size, **char**, or variable-size, **varchar**. Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)], when a UTF-8 enabled collation is used, these data types store the full range of [Unicode](../../relational-databases/collations/collation-and-unicode-support.md#Unicode_Defn) character data and use the [UTF-8](https://www.wikipedia.org/wiki/UTF-8) character encoding. If a non-UTF-8 collation is specified, then these data types store only a subset of characters supported by the corresponding code page of that collation.
 
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
-
 ## Arguments
 
 **char** [ ( *n* ) ]
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
@@ -29,8 +29,6 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 
 Numeric data types that have fixed precision and scale. Decimal and numeric are synonyms and can be used interchangeably.
   
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
-
 ## Arguments
 **decimal**[ **(**_p_[ **,**_s_] **)**] and **numeric**[ **(**_p_[ **,**_s_] **)**]  
 Fixed precision and scale numbers. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1. The ISO synonyms for **decimal** are **dec** and **dec(**_p_, _s_**)**. **numeric** is functionally identical to **decimal**.
diff --git a/docs/t-sql/data-types/float-and-real-transact-sql.md b/docs/t-sql/data-types/float-and-real-transact-sql.md
@@ -1,5 +1,5 @@
 ---
-title: "float and real (Transact-SQL) | Microsoft Docs"
+title: float and real (Transact-SQL)
 ms.custom: ""
 ms.date: "09/10/2019"
 ms.prod: sql
@@ -24,7 +24,9 @@ author: MikeRayMSFT
 ms.author: mikeray
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
+
 # float and real (Transact-SQL)
+
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be represented exactly. The ISO synonym for **real** is **float(24)**.
@@ -44,7 +46,9 @@ Where *n* is the number of bits that are used to store the mantissa of the **flo
 >  [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] treats *n* as one of two possible values. If **1**<=n<=**24**, *n* is treated as **24**. If **25**<=n<=**53**, *n* is treated as **53**.  
   
 The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] **float**[**(n)**] data type complies with the ISO standard for all values of *n* from **1** through **53**. The synonym for **double precision** is **float(53)**.
-  
+
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
 ## Remarks  
   
 |Data type|Range|Storage|  
diff --git a/docs/t-sql/data-types/getdescendant-database-engine.md b/docs/t-sql/data-types/getdescendant-database-engine.md
@@ -34,7 +34,7 @@ parent.GetDescendant ( child1 , child2 )
 -- CLR syntax  
 SqlHierarchyId GetDescendant ( SqlHierarchyId child1 , SqlHierarchyId child2 )   
 ```  
-  
+
 [!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
 
 ## Arguments
diff --git a/docs/t-sql/data-types/getlevel-database-engine.md b/docs/t-sql/data-types/getlevel-database-engine.md
@@ -18,7 +18,9 @@ ms.assetid: 81577d7e-8ff6-4e73-b7f4-94c03d4921e7
 author: MikeRayMSFT
 ms.author: mikeray
 ---
+
 # GetLevel (Database Engine)
+
 [!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
 
 Returns an integer that represents the depth of the node *this* in the tree.
@@ -34,7 +36,9 @@ node.GetLevel ( )
 -- CLR syntax  
 SqlInt16 GetLevel ( )   
 ```  
-  
+
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
 ## Return Types  
 **SQL Server return type:smallint**
   
diff --git a/docs/t-sql/data-types/getroot-database-engine.md b/docs/t-sql/data-types/getroot-database-engine.md
@@ -18,7 +18,9 @@ ms.assetid: 240b70f1-eeda-44ab-b4bb-9e4af80fa7c0
 author: MikeRayMSFT
 ms.author: mikeray
 ---
+
 # GetRoot (Database Engine)
+
 [!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
 
 Returns the root of the hierarchy tree. GetRoot() is a static method.
@@ -34,7 +36,9 @@ hierarchyid::GetRoot ( )
 -- CLR syntax  
 static SqlHierarchyId GetRoot ( )   
 ```  
-  
+
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
 ## Return Types  
 **SQL Server return type:hierarchyid**
   
diff --git a/docs/t-sql/data-types/isdescendantof-database-engine.md b/docs/t-sql/data-types/isdescendantof-database-engine.md
@@ -34,7 +34,7 @@ child. IsDescendantOf ( parent )
 -- CLR syntax  
 SqlHierarchyId IsDescendantOf (SqlHierarchyId parent )  
 ```  
-  
+
 [!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
 
 ## Arguments
diff --git a/docs/t-sql/data-types/nchar-and-nvarchar-transact-sql.md b/docs/t-sql/data-types/nchar-and-nvarchar-transact-sql.md
@@ -21,8 +21,6 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 Character data types that are either fixed-size, **nchar**, or variable-size, **nvarchar**. Starting with [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)], when a [Supplementary Character (SC)](../../relational-databases/collations/collation-and-unicode-support.md#Supplementary_Characters) enabled collation is used, these data types store the full range of [Unicode](../../relational-databases/collations/collation-and-unicode-support.md#Unicode_Defn) character data and use the [UTF-16](https://www.wikipedia.org/wiki/UTF-16) character encoding. If a non-SC collation is specified, then these data types store only the subset of character data supported by the [UCS-2](https://www.wikipedia.org/wiki/Universal_Coded_Character_Set#Encoding_forms) character encoding.
-  
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
 
 ## Arguments
 **nchar** [ ( n ) ]  
diff --git a/docs/t-sql/data-types/ntext-text-and-image-transact-sql.md b/docs/t-sql/data-types/ntext-text-and-image-transact-sql.md
@@ -29,9 +29,6 @@ Fixed and variable-length data types for storing large non-Unicode and Unicode c
   
 >**IMPORTANT!**  **ntext**, **text**, and **image** data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use [nvarchar(max)](../../t-sql/data-types/nchar-and-nvarchar-transact-sql.md), [varchar(max)](../../t-sql/data-types/char-and-varchar-transact-sql.md), and [varbinary(max)](../../t-sql/data-types/binary-and-varbinary-transact-sql.md) instead.  
   
-  
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
-
 ## Arguments
 **ntext**  
 Variable-length Unicode data with a maximum string length of 2^30 - 1 (1,073,741,823) bytes. Storage size, in bytes, is two times the string length that is entered. The ISO synonym for **ntext** is **national text**.
diff --git a/docs/t-sql/data-types/numeric-types.md b/docs/t-sql/data-types/numeric-types.md
@@ -25,6 +25,4 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 [decimal and numeric &#40;Transact-SQL&#41;](../../t-sql/data-types/decimal-and-numeric-transact-sql.md)  
 [float and real &#40;Transact-SQL&#41;](../../t-sql/data-types/float-and-real-transact-sql.md)  
 [int, bigint, smallint, and tinyint &#40;Transact-SQL&#41;](../../t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql.md)  
-[money and smallmoney &#40;Transact-SQL&#41;](../../t-sql/data-types/money-and-smallmoney-transact-sql.md)
-  
-  
+[money and smallmoney &#40;Transact-SQL&#41;](../../t-sql/data-types/money-and-smallmoney-transact-sql.md)
diff --git a/docs/t-sql/data-types/read-database-engine.md b/docs/t-sql/data-types/read-database-engine.md
@@ -35,8 +35,6 @@ I am making this fix now, from ```sql to ```cs, on 2020/04/16.  GeneMi.
 ```csharp
 void Read( BinaryReader r )   
 ```  
-  
-[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
 
 ## Arguments
 *r*  
diff --git a/docs/t-sql/data-types/smalldatetime-transact-sql.md b/docs/t-sql/data-types/smalldatetime-transact-sql.md
@@ -23,7 +23,9 @@ author: MikeRayMSFT
 ms.author: mikeray
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
+
 # smalldatetime (Transact-SQL)
+
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 Defines a date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00) and without fractional seconds.
diff --git a/docs/t-sql/data-types/sql-variant-transact-sql.md b/docs/t-sql/data-types/sql-variant-transact-sql.md
@@ -21,7 +21,9 @@ ms.assetid: 01229779-8bc1-4c7d-890a-8246d4899250
 author: MikeRayMSFT
 ms.author: mikeray
 ---
+
 # sql_variant (Transact-SQL)
+
 [!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
 
 A data type that stores values of various [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]-supported data types.
@@ -30,10 +32,12 @@ A data type that stores values of various [!INCLUDE[ssNoVersion](../../includes/
   
 ## Syntax  
   
-```sql
+```syntaxsql
 sql_variant  
 ```  
-  
+
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
 ## Remarks  
 **sql_variant** can be used in columns, parameters, variables, and the return values of user-defined functions. **sql_variant** enables these database objects to support values of other data types.
   
diff --git a/docs/t-sql/data-types/tostring-database-engine.md b/docs/t-sql/data-types/tostring-database-engine.md
@@ -1,5 +1,5 @@
 ---
-title: "ToString (Database Engine) | Microsoft Docs"
+title: ToString (Database Engine)
 ms.custom: ""
 ms.date: "07/23/2017"
 ms.prod: sql
@@ -18,7 +18,9 @@ ms.assetid: 5fc11ca5-c26d-4518-9512-67aa0270f110
 author: MikeRayMSFT
 ms.author: mikeray
 ---
+
 # ToString (Database Engine)
+
 [!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
 
 Returns a string with the logical representation of *this*. ToString is called implicitly when a conversion from **hierarchyid** to a string type occurs. Acts as the opposite of [Parse &#40;Database Engine&#41;](../../t-sql/data-types/parse-database-engine.md).
@@ -37,8 +39,11 @@ CAST(node AS nvarchar(4000))
 -- CLR syntax  
 string ToString  ( )   
 ```  
-  
+
+[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
+
 ## Return types
+
 **SQL Server return type:nvarchar(4000)**
   
 **CLR return type:String**
diff --git a/docs/t-sql/data-types/write-database-engine.md b/docs/t-sql/data-types/write-database-engine.md
@@ -28,7 +28,7 @@ Write writes out a binary representation of **SqlHierarchyId** to the passed-in
 ```sql
 void Write( BinaryWriter w )   
 ```  
-  
+
 [!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]
 
 ## Arguments
