Skip to content

Commit c2fa7a4

Browse files
TrishaMcTrishaMc
authored
Merge pull request MicrosoftDocs#6270 from v-kaywon/addmi2
 change headers to include managed instance in ole-db-blobs, ole-db-commands, ole-db-data-source-objects, ole-db-data-types, ole-db-date-time, and ole-db-driver directories
2 parents e83d7c5 + 2d54d57 commit c2fa7a4

37 files changed

Lines changed: 187 additions & 76 deletions

File tree

‎docs/connect/oledb/ole-db-blobs/blobs-and-ole-objects.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "BLOBs and OLE Objects | Microsoft Docs"
33
description: "BLOBs and OLE Objects"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-blobs"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -21,7 +22,9 @@ ms.author: "Pedro.Lopes"
2122
manager: craigg
2223
---
2324
# BLOBs and OLE Objects
24-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
25+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
26+
27+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2528

2629
The OLE DB Driver for SQL Server exposes the **ISequentialStream** interface to support consumer access to [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] **ntext**, **text**, **image**, **varchar(max)**, **nvarchar(max)**, **varbinary(max)**, and xml data types as binary large objects (BLOBs). The **Read** method on **ISequentialStream** lets the consumer retrieve much data in manageable chunks.
2730

‎docs/connect/oledb/ole-db-blobs/getting-large-data.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Getting Large Data | Microsoft Docs"
33
description: "Getting large data using OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-blobs"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -20,7 +21,9 @@ ms.author: "Pedro.Lopes"
2021
manager: craigg
2122
---
2223
# Getting Large Data
23-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
25+
26+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2427

2528
In general, consumers should isolate code that creates an OLE DB Driver for SQL Server storage object from other code that handles data that is not referenced through an **ISequentialStream** interface pointer.
2629

‎docs/connect/oledb/ole-db-blobs/setting-large-data.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Setting Large Data | Microsoft Docs"
33
description: "Setting large data using OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-blobs"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -21,7 +22,9 @@ ms.author: "Pedro.Lopes"
2122
manager: craigg
2223
---
2324
# Setting Large Data
24-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
25+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
26+
27+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2528

2629
With the OLE DB Driver for SQL Server, you can set BLOB data by passing a pointer to a consumer storage object.
2730

‎docs/connect/oledb/ole-db-blobs/streaming-support-for-blob-output-parameters.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Streaming Support for BLOB Output Parameters | Microsoft Docs"
33
description: "Streaming support for BLOB output parameters"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-blobs"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -17,7 +18,9 @@ ms.author: "Pedro.Lopes"
1718
manager: craigg
1819
---
1920
# Streaming Support for BLOB Output Parameters
20-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
21+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
22+
23+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2124

2225
This article contains a sample that shows streaming support for BLOB output parameters, which binds BLOB output parameters as ISequentialStreams.
2326

‎docs/connect/oledb/ole-db-commands/command-parameters.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Command Parameters | Microsoft Docs"
33
description: "Command parameters"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -21,7 +22,9 @@ ms.author: "Pedro.Lopes"
2122
manager: craigg
2223
---
2324
# Command Parameters
24-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
25+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
26+
27+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2528

2629
Parameters are marked in command text with the question mark character. For example, the following SQL statement is marked for a single input parameter:
2730

‎docs/connect/oledb/ole-db-commands/command-syntax.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Command Syntax | Microsoft Docs"
33
description: "Command syntax and Stored Procedures"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -20,7 +21,9 @@ ms.author: "Pedro.Lopes"
2021
manager: craigg
2122
---
2223
# Command Syntax
23-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
25+
26+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2427

2528
The OLE DB Driver for SQL Server recognizes command syntax specified by the DBGUID_SQL macro. For the OLE DB Driver for SQL Server, the specifier indicates that an amalgam of ODBC SQL, ISO, and [!INCLUDE[tsql](../../../includes/tsql-md.md)] is valid syntax. For example, the following SQL statement uses an ODBC SQL escape sequence to specify the LCASE string function:
2629

‎docs/connect/oledb/ole-db-commands/commands-generating-multiple-rowset-results.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Commands Generating Multiple-Rowset Results | Microsoft Docs"
33
description: "Commands generating multiple-rowset results"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -22,7 +23,9 @@ ms.author: "Pedro.Lopes"
2223
manager: craigg
2324
---
2425
# Commands Generating Multiple-Rowset Results
25-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
26+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
27+
28+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2629

2730
The OLE DB Driver for SQL Server can return multiple rowsets from [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] statements. [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] statements return multiple-rowset results under the following conditions:
2831

‎docs/connect/oledb/ole-db-commands/commands.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Commands | Microsoft Docs"
33
description: "Commands in OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -18,7 +19,9 @@ ms.author: "Pedro.Lopes"
1819
manager: craigg
1920
---
2021
# Commands
21-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
22+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
23+
24+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2225

2326
The OLE DB Driver for SQL Server exposes the **ICommand** interface and command objects, which are described in this section:
2427

‎docs/connect/oledb/ole-db-commands/preparing-commands.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Preparing Commands | Microsoft Docs"
33
description: "Preparing commands using OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -20,7 +21,9 @@ ms.author: "Pedro.Lopes"
2021
manager: craigg
2122
---
2223
# Preparing Commands
23-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
25+
26+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2427

2528
The OLE DB Driver for SQL Server supports command preparation for optimized multiple execution of a single command; however, command preparation generates overhead, and a consumer does not need to prepare a command to execute it more than once. In general, a command should be prepared if it will be executed more than three times.
2629

‎docs/connect/oledb/ole-db-commands/using-imultipleresults-to-process-multiple-result-sets.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Using IMultipleResults to Process Multiple Result Sets | Microsoft Docs"
33
description: "Using IMultipleResults to process multiple result sets"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-commands"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -20,7 +21,9 @@ ms.author: "Pedro.Lopes"
2021
manager: craigg
2122
---
2223
# Using IMultipleResults to Process Multiple Result Sets
23-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
25+
26+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2427

2528
Consumers use the **IMultipleResults** interface to process results returned by OLE DB Driver for SQL Server command execution. When the OLE DB Driver for SQL Server submits a command for execution, [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] executes the statements and returns any results.
2629

0 commit comments

Comments
 (0)