Skip to content

Commit 3a498bd

Browse files
author
Bruce Hamilton
committed
Metadata updates for t-sql 1 of 2
1 parent d44fc8d commit 3a498bd

551 files changed

Lines changed: 2820 additions & 1173 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/t-sql/data-types/binary-and-varbinary-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "binary and varbinary (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "8/16/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -27,7 +30,7 @@ manager: "cguyer"
2730
ms.workload: "Active"
2831
---
2932
# binary and varbinary (Transact-SQL)
30-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
33+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
3134

3235
Binary data types of either fixed length or variable length.
3336

‎docs/t-sql/data-types/bit-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "bit (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -24,7 +27,7 @@ manager: "cguyer"
2427
ms.workload: "Active"
2528
---
2629
# bit (Transact-SQL)
27-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
30+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
2831

2932
An integer data type that can take a value of 1, 0, or NULL.
3033

‎docs/t-sql/data-types/char-and-varchar-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "char and varchar (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -29,7 +32,7 @@ manager: "cguyer"
2932
ms.workload: "Active"
3033
---
3134
# char and varchar (Transact-SQL)
32-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
35+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
3336

3437
These data types are of either fixed length or variable length.
3538

‎docs/t-sql/data-types/constants-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Constants (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/22/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -38,7 +41,7 @@ manager: "cguyer"
3841
ms.workload: "On Demand"
3942
---
4043
# Constants (Transact-SQL)
41-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
44+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
4245

4346
A constant, also known as a literal or a scalar value, is a symbol that represents a specific data value. The format of a constant depends on the data type of the value it represents.
4447

‎docs/t-sql/data-types/cursor-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "cursor (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -21,7 +24,7 @@ manager: "cguyer"
2124
ms.workload: "On Demand"
2225
---
2326
# cursor (Transact-SQL)
24-
[!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md)]
27+
[!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md)]
2528

2629
A data type for variables or stored procedure OUTPUT parameters that contain a reference to a cursor.
2730

‎docs/t-sql/data-types/data-type-conversion-database-engine.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Data type conversion (Database Engine) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -27,7 +30,7 @@ manager: "cguyer"
2730
ms.workload: "Active"
2831
---
2932
# Data type conversion (Database Engine)
30-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
33+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
3134

3235
Data types can be converted in the following scenarios:
3336
- When data from one object is moved to, compared with, or combined with data from another object, the data may have to be converted from the data type of one object to the data type of the other.

‎docs/t-sql/data-types/data-type-precedence-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Data Type Precedence (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "sql-database"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -25,7 +28,7 @@ manager: "cguyer"
2528
ms.workload: "On Demand"
2629
---
2730
# Data type precedence (Transact-SQL)
28-
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
31+
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
2932

3033
When an operator combines two expressions of different data types, the rules for data type precedence specify that the data type with the lower precedence is converted to the data type with the higher precedence. If the conversion is not a supported implicit conversion, an error is returned. When both operand expressions have the same data type, the result of the operation has that data type.
3134

‎docs/t-sql/data-types/data-type-synonyms-transact-sql.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Data type synonyms (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "sql-database"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -23,7 +26,7 @@ manager: "cguyer"
2326
ms.workload: "On Demand"
2427
---
2528
# Data type synonyms (Transact-SQL)
26-
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
29+
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
2730

2831
Data type synonyms are included in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] for ISO compatibility. The following table lists the synonyms and the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] system data types that they map to.
2932

‎docs/t-sql/data-types/data-types-transact-sql.md‎

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Data types (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "9/13/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology: "database-engine"
912
ms.tgt_pltfrm: ""
1013
ms.topic: "language-reference"
@@ -21,9 +24,8 @@ ms.author: "edmaca"
2124
manager: "cguyer"
2225
ms.workload: "Active"
2326
---
24-
2527
# Data types (Transact-SQL)
26-
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
28+
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
2729

2830
In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], each column, local variable, expression, and parameter has a related data type. A data type is an attribute that specifies the type of data that the object can hold: integer data, character data, monetary data, date and time data, binary strings, and so on.
2931

‎docs/t-sql/data-types/date-and-time-types.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ title: "Date and time types | Microsoft Docs"
33
ms.custom: ""
44
ms.date: "7/23/2017"
55
ms.prod: "sql-non-specified"
6+
ms.prod_service: "sql-database"
7+
ms.service: ""
8+
ms.component: "t-sql|data-types"
69
ms.reviewer: ""
7-
ms.suite: ""
10+
ms.suite: "sql"
811
ms.technology:
912
- "database-engine"
1013
ms.tgt_pltfrm: ""
@@ -19,7 +22,7 @@ manager: "cguyer"
1922
ms.workload: "On Demand"
2023
---
2124
# Date and time types
22-
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
25+
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]
2326

2427
[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports the following date and time types.
2528

0 commit comments

Comments
 (0)