SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1393 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 NgHdZN
Related Questions
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
SQL Server : What is the purpose of SET NOCOUNT ON?

What is the purpose of SET NOCOUNT ON?

Whenever a Select Statement or any DML Statement is executed the server return a value that is the n....
Category: SQL Server Date: 10/1/2010 12:07:08 PM