What is BCP? When do we use it?

Answer Posted / guest

BulkCopy is a tool used to copy huge amount of data from
tables and views. But it won?t copy the structures of the same.

Is This Answer Correct ?    8 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by a view? What does the with check option clause for a view do?

684


what information is maintained within the msdb database? : Sql server administration

590


Explain the Ways to improve the performance of a sql azure database?

72


Explain the concept of view and Types of views in SQL server?

706


What is raid and what are different types of raid levels?

687






Can I run multiple instances of sql server 2000 at the same time on one computer?

698


What is user-defined functions? What are the types of user-defined functions that can be created?

655


How secure is sql server database?

601


Write a sql query to sort on different column name according to the parameters passed in the function?

612


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

645


can you implement data mining in SSRS?

117


Explain filtered indexes?

652


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

612


What is the difference between inner join and equi join?

573


How to populate a table in sql server?

592