what is bcp? When is it used?



what is bcp? When is it used?..

Answer / Suresh Prasad

BCP (Bulk Copy Program) is a utility in SQL Server used for bulk loading or unloading data from SQL Server to or from flat files, such as CSV or TXT files. It's used when dealing with large amounts of data, as it provides better performance compared to traditional methods like INSERT statements.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql record in oracle?

1 Answers  


Compare sql & pl/sql

1 Answers  


Explain autonomous transaction.

1 Answers  


What is cascade in sql?

1 Answers  


What are advantages of Stored Procedures?

3 Answers   Satyam,


what is the difference between $message and $$message? : Sql dba

1 Answers  


How do I know if I have sql express or standard?

1 Answers  


Can we change the table name in sql?

1 Answers  


What is the difference between Union and Union all. Which is faster.

1 Answers  


What are the properties of a transaction?

1 Answers  


What are character functions in sql?

1 Answers  


write an sql query to find names of employee start with 'a'? : Sql dba

1 Answers  


Categories