SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1280 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 bgHycd
Related Questions
SQL Server : Differentiate between Dynamic SQL and Static SQL?

Differentiate between Dynamic SQL and Static SQL?

Static SQL:- Static queries are the simple queries which are directly embeded into the program. They....
Category: SQL Server Date: 10/1/2010 11:49:07 AM
SQL Server : What is blocking and how this problem can be solved out?

What is blocking and how this problem can be solved out?

Blocking occurs when one process holds a lock and the other process requires a conflicting lock type....
Category: SQL Server Date: 10/1/2010 11:48:07 AM
SQL Server : Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary table only?

Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary ta....

No,Temporary table is not compulsory.It can be deleted without craeting temporary table by using ROW....
Category: SQL Server Date: 10/1/2010 11:47:07 AM
SQL Server : What  is SQL Job and what are its uses?

What is SQL Job and what are its uses?

SQL Job is set of specified operations set on server to be performed sequentially and automatically.....
Category: SQL Server Date: 10/1/2010 11:45:07 AM
SQL Server : Is it possible to create a Primary Key and Unique Key on Computed columns?

Is it possible to create a Primary Key and Unique Key on Computed columns?

Yes, it is possible to create a Primary ke and unique key on computed columns. In case of Unique key....
Category: SQL Server Date: 10/1/2010 11:44:07 AM