SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1308 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 PhEPfn
Related Questions
SQL Server : To change or set the permissions in SQL server which particular commands are used?

To change or set the permissions in SQL server which particular commands are used?

There are basic three commands viz.:- GRANT,DENY and REVOKE
Category: SQL Server Date: 10/1/2010 11:32:07 AM
SQL Server : Give some difference between Where Clause and Having Clause?

Give some difference between Where Clause and Having Clause?

1. HAVING can't be used without GROUP BY Clause but WHERE Clause can be used without GROUP By. 2. WH....
Category: SQL Server Date: 10/1/2010 11:31:07 AM
SQL Server : What is timestamp in SQL server?

What is timestamp in SQL server?

timestamp is a datatype in SQL server. This datatype generates binary number , which are unique with....
Category: SQL Server Date: 10/1/2010 11:30:07 AM
SQL Server : Which conditions are to be kept in mind while using the FOR BROWSE Option in SELECT statement?

Which conditions are to be kept in mind while using the FOR BROWSE Option in SELECT statement?

Following are the conditions:- 1. The table should have time-stamped column with timestamp as datat....
Category: SQL Server Date: 10/1/2010 11:29:07 AM
SQL Server : What is the purpose of FOR BROWSE option in the SELECT statement?

What is the purpose of FOR BROWSE option in the SELECT statement?

FOR BROWSE option which is used at the end of the SELECT statement allows the user to perform the up....
Category: SQL Server Date: 10/1/2010 11:28:07 AM