| title | Bulk import large-object data with OPENROWSET bulk rowset provider | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| description | The SQL Server OPENROWSET Bulk Rowset Provider enables bulk import as large-object data. Supported types are varbinary(max), varchar(max), and nvarchar(max). | ||||||||
| ms.date | 03/14/2017 | ||||||||
| ms.prod | sql | ||||||||
| ms.prod_service | database-engine | ||||||||
| ms.reviewer | |||||||||
| ms.technology | data-movement | ||||||||
| ms.topic | conceptual | ||||||||
| helpviewer_keywords |
|
||||||||
| ms.assetid | 171cdd5c-1e47-4bd7-b99a-4f0fd4e10526 | ||||||||
| author | MashaMSFT | ||||||||
| ms.author | mathoma | ||||||||
| ms.custom | seo-lt-2019 |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
The [!INCLUDEssNoVersion] OPENROWSET Bulk Rowset Provider enables you to bulk import a data file as large-object data.
The large-object data types supported by OPENROWSET Bulk Rowset Provider are varbinary(max) or image, varchar(max) or text, and nvarchar(max) or ntext.
Note
The image, text and ntext data types are deprecated.
The OPENROWSET BULK clause supports three options for importing the contents of a data file as a single-row, single-column rowset. You can specify one of these large-object options instead of using a format file. These options are as follows:
SINGLE_BLOB
Reads the contents of data_file as a single-row, returns the contents as a single-column rowset of type varbinary(max).
SINGLE_CLOB
Reads the contents of the specified data file as characters, returns the contents as a single-row, single-column rowset of type varchar(max), using the collation of the current database; such as a text or [!INCLUDEmsCoName] Word document.
SINGLE_NCLOB
Reads the contents of the specified data file as Unicode, returns the contents as a single-row, single-column rowset of type nvarchar(max), using the collation of the current database.
Import Bulk Data by Using BULK INSERT or OPENROWSET(BULK...) (SQL Server)
BACKUP (Transact-SQL)
OPENROWSET (Transact-SQL)
Keep Nulls or Use Default Values During Bulk Import (SQL Server)
bcp Utility
BULK INSERT (Transact-SQL)