SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1269 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 H3H3SW
Related Questions
SQL Server : What is the difference between UNION and UNION ALL Statements?

What is the difference between UNION and UNION ALL Statements?

UNION command selects distinct and related information from two tables while UNION ALL selects all t....
Category: SQL Server Date: 10/7/2009 3:19:40 AM
SQL Server : What is the difference between VARCHAR and NVARCHAR type?

What is the difference between VARCHAR and NVARCHAR type?

VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string o....
Category: SQL Server Date: 10/7/2009 3:09:18 AM
SQL Server : What is SQL injection attack?

What is SQL injection attack?

SQL injection is an attack in which malicious code is inserted into strings that are later passed to....
Category: SQL Server Date: 10/2/2009 7:12:03 AM
SQL Server : Why we use SET ROWCOUNT statement in SQL Server?

Why we use SET ROWCOUNT statement in SQL Server?

It causes SQL Server to stop processing the query after the specified number of rows (e.g. SET ROWCO....
Category: SQL Server Date: 10/2/2009 7:03:39 AM
SQL Server : How can we delete the duplicate rows from a  table?

How can we delete the duplicate rows from a table?

Lets consider if we have a table Employee with rowid, name and email columns. Then we can use follow....
Category: SQL Server Date: 9/19/2009 4:58:46 AM