What is BCP? When does it used in sql server 2012?



What is BCP? When does it used in sql server 2012?..

Answer / Snigdha Jauhari

{"BCP" (Bulk Copy Program) is a utility provided by Microsoft SQL Server to efficiently transfer data between a SQL Server database and other data sources like Excel, text files, Access databases, etc. It's particularly useful for loading large amounts of data quickly. In SQL Server 2012, BCP can be used during bulk load operations when the source or destination is not a SQL Server table (e.g., CSV file).}

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain encryption of entire databases without the need for application changes in sql server 2008?

1 Answers  


What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

1 Answers  


How to define the name and server for a new dsn?

1 Answers  


What is the user of Primary key?

1 Answers  


What are the advantages of having an index on the sql server?

1 Answers  


How to create nested stored procedure?

1 Answers  


How to create stored procedures with parameters in ms sql server?

1 Answers  


How do I trace a query in sql server?

1 Answers  


where can you add custom error messages to sql server? : Sql server administration

1 Answers  


How can you check the level of fragmentation on a table?

1 Answers  


How to implement service broker?

1 Answers  


Categories