SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1078 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 ilBq6l
Related Questions
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
SQL Server : What is the maximum length of a varchar field in SQL Server?

What is the maximum length of a varchar field in SQL Server?

Variable-length data with a maximum of 8,000 characters.
Category: SQL Server Date: 10/30/2009 7:51:03 AM
SQL Server : What authentication mechanisms does Microsoft SQL Server support?

What authentication mechanisms does Microsoft SQL Server support?

SQL Server supports following two type of authentication mechanisms: 1) Windows Authentication (via....
Category: SQL Server Date: 10/15/2009 4:43:44 AM