Advantages and disadvantages of certain SQL commands
Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 19, 2008 3:08 PM
UPDATED:
November 19, 2008 5:06 PM
Answer Wiki:
<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>
<a href="http://www.paladn.com/bulk-copy-program.htm">Bulk Copy Program (BCP)- Microsoft SQL Server 2000 Tool </a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
