COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The normal use of Bulk Copy Program (bcp) does require advanced knowledge of Transact-SQL.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Detailed explanation-2: -BCP has less parsing efforts and cost than BULK INSERT. Both are almost same and give almost same performance. If you want test or compare them performance, they must in the same system and do the same operation: loading data file into Azure SQL Server via BLOB storage or load data file into Azure SQL server.
There is 1 question to complete.