SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1101 Page Views: 

What is the purpose of bcp utility?



Posted By: Avi Date: 1 October 2010 11:52:07 AM
 Answer:

bcp utility copies bulk data between an instance of SQL server database and user defined file format. This utility can be used to import as well as export data into the tables and out of the tables respectively. For eg If you want to convert SQL file to plain text file and copy it to other application then it can be done as follows:- bcp out databasename.dbo.tablename Filename.txt -T -C


Posted By: avibtech


Date: 1 October 2010 11:52:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image iOIQ3x
Related Questions
SQL Server : What are distributed Queries?

What are distributed Queries?

Distributed Queries are the queries which can access multiple hetrogeneous data from different sourc....
Category: SQL Server Date: 10/1/2010 12:06:08 PM
SQL Server : When do the database checkpoints occur?

When do the database checkpoints occur?

Check point will occur in the following cases:- 1. It can be added manually . The Syntax is:- CHEC....
Category: SQL Server Date: 10/1/2010 12:05:08 PM
SQL Server : What is the purpose of the checkpoint?

What is the purpose of the checkpoint?

Whenever an operation is performed in SQL Server it is not committed directly to the database.All th....
Category: SQL Server Date: 10/1/2010 12:04:08 PM
SQL Server : What do you mean by dirty pages in SQL Server?

What do you mean by dirty pages in SQL Server?

Dirty pages in SQL server are the data pages which have been modified and are still lying in the buf....
Category: SQL Server Date: 10/1/2010 12:03:08 PM
SQL Server : The table was deleted. Now is there any way to get it back?

The table was deleted. Now is there any way to get it back?

Yes, the logs can be used to fetch the deleted table.For this one has to use some some external tool....
Category: SQL Server Date: 10/1/2010 12:02:08 PM