SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1372 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 9FDU7s
Related Questions
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
SQL Server : How can we find the number of rows in a table?

How can we find the number of rows in a table?

Following SQL statements can be used to get the number of rows in a table: SQL Query - 1: SELECT CO....
Category: SQL Server Date: 9/19/2009 4:51:20 AM
SQL Server : Write down the general syntax for a SELECT statement covering all the options.

Write down the general syntax for a SELECT statement covering all the options.

SELECT select_list [INTO new_table] FROM table_source [WHERE search_condition] [GROUP BY group_by_ex....
Category: SQL Server Date: 9/19/2009 4:24:23 AM
SQL Server : Whatis the difference between DELETE TABLE and TRUNCATE TABLE commands?

Whatis the difference between DELETE TABLE and TRUNCATE TABLE commands?

DELETE TABLE command is used to delete all the rows in a table. It is a logged operation, means the ....
Category: SQL Server Date: 9/19/2009 4:17:27 AM