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.
Showing posts with label bulk insert. Show all posts
Showing posts with label bulk insert. Show all posts
Friday, January 29, 2010
Subscribe to:
Posts (Atom)