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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |