![]() ![]() Specifies the file used to collect rows that have formatting errors and can't be converted to an OLE DB rowset. For an example, see Import data from a file in Azure Blob Storage. For more information, see CREATE EXTERNAL DATA SOURCE. The external data source must be created using the TYPE = BLOB_STORAGE option added in SQL Server 2017 (14.x). Specifies a named external data source pointing to the Azure Blob Storage location of the file that will be imported. If the data file contains ANSI extended characters, specify widenative.įor more information, see Use Unicode Native Format to Import or Export Data (SQL Server).Īpplies to: SQL Server 2017 (14.x) and Azure SQL Database. The widenative value offers a higher performance alternative to widechar. ![]() Create the widenative data file by bulk importing data from SQL Server using the bcp utility. Native (database) data types, except in char, varchar, and text columns, in which data is stored as Unicode. Native format is recommended when you bulk transfer data between multiple instances of SQL Server using a data file that doesn't contain any extended/double-byte character set (DBCS) characters.įor more information, see Use Native Format to Import or Export Data (SQL Server).įor more information, see Use Unicode Character Format to Import or Export Data (SQL Server). The native value offers a higher performance alternative to the char value. Create the native data file by bulk importing data from SQL Server using the bcp utility. ![]() DATAFILETYPE valueįor more information, see Use Character Format to Import or Export Data (SQL Server). Specifies that BULK INSERT performs the import operation using the specified data-file type value. Transact-SQL syntax conventions Syntax BULK INSERT Imports a data file into a database table or view in a user-specified format in SQL Server Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |