Just tried to find out the real difference between bcp utility and bulk insert statement and here is the article from Microsoft's official site.
Quoted too: "The BULK INSERT statement allows you to bulk copy data to an instance of SQL Server using the functionality of the bcp utility with a Transact-SQL statement, rather than from the command prompt."
Therefore, it seems the whole "bulk insert" statement is purely another way of "bcp in" command.
Friday, January 29, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment