SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1029 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 nmw1Wt
Related Questions
SQL Server : What is the maximum number of columns sorted using ORDER BY Clause in Select Clause?
SQL Server : Which NET-Libraries are not supported by named instances of SQL Server?

Which NET-Libraries are not supported by named instances of SQL Server?

Multiprotocol , Appletalk , or Banyan vines are the net Libraries supported by named instances. They....
Category: SQL Server Date: 10/1/2010 12:31:08 PM
SQL Server : Which performance monitor counter is used to show the memory used by the process?

Which performance monitor counter is used to show the memory used by the process?

The Performance Monitor Process: Working Set counter shows the amount ofmemory used by a process.
Category: SQL Server Date: 10/1/2010 12:30:08 PM
SQL Server : How many Logical tables are available in the triggers?

How many Logical tables are available in the triggers?

Whenever the triggers are used there exists two logical tables viz. Deleted table and Inserted table....
Category: SQL Server Date: 10/1/2010 12:29:08 PM
SQL Server : Which SQL Statement is used to show fragmentation information for data and indexes of the specified table?
 
Find Best Deals @