SQL Server在这方面非常糟糕，请在此处查看Bulk Insert:
批量插入(Transact-SQL) [使用批量插入来加载文本文件 [ ^ ]

SQL Server is notoriously bad in this regard, take a look at Bulk Insert here:
BULK INSERT (Transact-SQL)[^]

Using BULK INSERT to Load a Text File[^]