SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1030 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 QQ10Gs
Related Questions
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
SQL Server : What is the basic concept of Serialization?

What is the basic concept of Serialization?

Serialization is the highest level of isolation. When Serialization is implemented then there will b....
Category: SQL Server Date: 10/1/2010 11:43:07 AM
SQL Server : Write the query to Select the name of the product whose total sales is 20 form the following table named sales:-
PID    Pname      Sale
1        Soap         5
2        Brush       10
3        Tea          8
1        Soap        12
2        Brush       5

Write the query to Select the name of the product whose total sales is 20 form the following table n....

select Pname from sales group by PID having sum(sale)=130
Category: SQL Server Date: 10/1/2010 11:42:07 AM
 
Find Best Deals @