SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1086 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 6sWgrG
Related Questions
SQL Server : Which SQL statement doesn't support HOLDLOCK?

Which SQL statement doesn't support HOLDLOCK?

HOLDLOCK cannot be used with the SELECT statement which is having FOR BROWSE option.
Category: SQL Server Date: 10/1/2010 11:27:07 AM
SQL Server : What is HOLDLOCK in SQL?

What is HOLDLOCK in SQL?

HOLDLOCK option directs the SQL server to hold shared lock untill and unless the transaction is comp....
Category: SQL Server Date: 10/1/2010 11:26:07 AM
SQL Server : Discuss how Exclusive Locks are not compatible with other locks.

Discuss how Exclusive Locks are not compatible with other locks.

Exclusive Locks are not compatible with other lock types such as Shared Locks and Update Locks. Exam....
Category: SQL Server Date: 10/1/2010 11:25:07 AM
SQL Server : What is the purpose of the NOLOCK option?

What is the purpose of the NOLOCK option?

Basically when locks are used user is unable to read the uncommited data , but with the help of this....
Category: SQL Server Date: 10/1/2010 11:24:07 AM
SQL Server : What is the difference between a live lock and a deadlock?

What is the difference between a live lock and a deadlock?

Live Lock:- In Live Lock the user is only able to read the transaction of the table and is unable to....
Category: SQL Server Date: 10/1/2010 11:23:07 AM