SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1247 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 0q3ZHh
Related Questions
SQL Server : What is meant by View?

What is meant by View?

In a datbase there are sevral tables and if you want to view some specific fields from multiple tabl....
Category: SQL Server Date: 10/1/2010 12:12:08 PM
SQL Server : What is the function of STUFF in SQL Server?

What is the function of STUFF in SQL Server?

STUFF function inserts one string into the other. Basically it deletes the specified length of the f....
Category: SQL Server Date: 10/1/2010 12:11:08 PM
SQL Server : Give the query to get the 4th highest salary from emp table.

Give the query to get the 4th highest salary from emp table.

SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 4 salary FROM emp ORDER BY salary DESC) a ORDER BY sa....
Category: SQL Server Date: 10/1/2010 12:10:08 PM
SQL Server : What are the components of a Linked Server?

What are the components of a Linked Server?

Linked Server possess two main Components;- 1. An OLE DB Provider:- Is a DLL which manages and int....
Category: SQL Server Date: 10/1/2010 12:09:08 PM
SQL Server : What is a linked server?

What is a linked server?

Linked server is a server which allows remote access. It enables SQL Server to execute commands on r....
Category: SQL Server Date: 10/1/2010 12:08:08 PM