![]() Load data into program variables, then import the data into a table or view using the bulk copy functions for bulk copying in a row at a time.ĭata files used by bulk copy functions do not have to be created by another bulk copy program. If needed, a format file is used to determine the layout of the data file. If all columns are converted to character format, the resulting file is called a character-mode data file.īulk copy from a data file into a table or view. In this case, a separate format file is created that defines the characteristics (data type, position, length, terminator, and so on) of each column as it is stored in the data file. Optionally, data can be loaded into program variables and transferred to SQL Server using bulk copy functions and methods.įor a sample application that demonstrates this feature, see Bulk Copy Data Using IRowsetFastLoad (OLE DB).Īn application typically uses bulk copy in one of the following ways:īulk copy from a table, view, or the result set of a Transact-SQL statement into a data file where the data is stored in the same format as the table or view.īulk copy from a table, view, or the result set of a Transact-SQL statement into a data file where the data is stored in a format other than the one of the table or view. The data file can have different formats the format is defined to bulk copy in a format file. The data can be moved between SQL Server and an operating-system data file, such as an ASCII file. Data can also be transferred out by specifying a SELECT statement. The SQL Server bulk copy feature supports the transfer of large amounts of data into or out of a SQL Server table or view. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |