What is BCP utility in SQL SERVER?

The Bulk Copy Program (BCP) is a command line utility by which you can import & export large amounts of data in and out of the SQL SERVER database.

The sample below shows the BCP in action.

Figure :-Export BCP utility in action

Figure :-Import BCP utility in action

Posted Date: 9/24/2012 3:26:54 AM | Location : United States

Ask an Expert

Related Discussions:- Bcp utility in sql server, Assignment Help, Ask Question on Bcp utility in sql server, Get Answer, Expert's Help, Bcp utility in sql server Discussions

Write discussion on Bcp utility in sql server
Your posts are moderated

Write your message here..

Related Questions

Bcp utility in sql server, What is BCP utility in SQL SERVER? The Bulk ... What is BCP utility in SQL SERVER? The Bulk Copy Program (BCP) is a command line utility by which you can import & export large amounts of data in and out of the SQL SERVER dat

Code for the file dependency in cache, Show the code for the file dependenc... Show the code for the file dependency in cache? Partial Class Default_aspx Public Sub displayAnnouncement() Dim announcement As String If Cache("announcement") Is Noth

Classic ado and ado.net , What are major difference between classic ADO and... What are major difference between classic ADO and ADO.NET ? Some major differences between the classic ADO & ADO.NET are as follows: 1) As in the classic ADO we had server a

Pollution software vehicle, Project Description: i want to prepare a pol... Project Description: i want to prepare a pollution checking software.. i have a demo of it.. Exactly someone to be created ..some changes to be included.. sms gateway t

Implement singleton pattern in .net, How can we implement singleton pattern... How can we implement singleton pattern in .NET ? The Singleton pattern basically focuses on having one and only one instance of the object running. Lets take an e.g. a windows

Benefits and limitation of viewstate for state management, What are benefit... What are benefits and Limitation of using Viewstate for state management The benefits of using Viewstate are as follows:- 1)    There is no server resources required because

What is a delegate, What is a delegate? A delegate is similar to a clas... What is a delegate? A delegate is similar to a class that is used for storing the reference to a method and invoking that method at runtime, as needed. A delegate can hold the

Importance of it governance, Importance of IT governance Governing and ... Importance of IT governance Governing and managing information technology is a crucial activity in organizations to generate business value. According to Ross & Weill (2004), f

Read an array and perform sorting - c# program, Read an Array and perform S... Read an Array and perform Sorting - C# program Can any one assist me in performing sorting of an array.

I need some a vba expert urgent, I need some a VBA expert urgent Project... I need some a VBA expert urgent Project Description: I require a VBA expert for scraping data from internet. .NET, Excel, Data Processing, Visual Basic