<a href="http://www.sqlcommands.net/">Here is a good reference.</a>
BCP is not a command, is a tool.
The main advantage of BCP is that, the user is not forced to have knowledge of T-SQL.
BULK INSERT is the T-SQL command for the BCP utility, and the advantage is that it can be used within stored procedures or the query analyzer.
SELECT INTO is used to create a table from a query.
More information can be found in the following pages:
<a href="http://www.devguru.com/technologies/t-sql/7126.asp">T-SQL » Statements » SELECT INTO</a>
<a href="http://www.mssqltips.com/tip.asp?tip=1207">Different Options for Importing Data into SQL Server</a>
<a href="http://www.wwwcoder.com/main/parentid/191/site/4166/68/default.aspx">SQL: Importing and Exporting Data
<a href="http://www.paladn.com/bulk-copy-program.htm">Bulk Copy Program (BCP)- Microsoft SQL Server 2000 Tool </a>
Last Wiki Answer Submitted: November 19, 2008 5:06 pm by Technochic56,975 pts.
All Answer Wiki Contributors: Technochic56,975 pts.