SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1472 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 swp4PD
Related Questions
SQL Server : Having a table which is refrenced by Foreign Key. Can the TRUNCATE command be executed on that table?

Having a table which is refrenced by Foreign Key. Can the TRUNCATE command be executed on that table....

No,it is not possible . Because according to refrential integrity the table with the foreign can not....
Category: SQL Server Date: 10/1/2010 11:02:06 AM
SQL Server : Which command is used to display the current distribution statistics ?

Which command is used to display the current distribution statistics ?

DBCC SHOW_STATISTICS is the command used for displaying the current distribution statistics. Synatx:....
Category: SQL Server Date: 10/1/2010 11:01:06 AM
SQL Server : What is UPDATE_STATISTICS command?

What is UPDATE_STATISTICS command?

This command is used when we are dealing with large amount of data, i.e. when deletion or copying of....
Category: SQL Server Date: 10/1/2010 11:00:06 AM
SQL Server : Is Delete and Truncate one are the same thing?

Is Delete and Truncate one are the same thing?

No , both are different commands being used in SQL Server. Delete command is used to delete the row....
Category: SQL Server Date: 10/1/2010 10:55:06 AM
SQL Server : Which Port is assigned to run SQL Server? Can the Default port be changed?

Which Port is assigned to run SQL Server? Can the Default port be changed?

1433 is the TCP/IP port which is required to run SQL Server . Yes, default port can be changed for ....
Category: SQL Server Date: 10/1/2010 10:54:06 AM