Bulk Insert

Bulk Insert is a fairly common function, but not so common that I can remember the syntax every time. Here I’ve posted the version I use most:

Note that Bulk Insert does not support skipping headers. The source file should not include headers otherwise the load will fail.

More about Bulk Insert:

Transact-SQL : BULK INSERT

Leave a Reply

Your email address will not be published.

HTML tags are not allowed.