且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将非常大的csv文件导入到现有的SQL Server表中?

更新时间:2022-05-27 22:05:39

最后一行很可能缺少\n.另外,尽管T-SQL应该提到这一点,但SQL-Server中的行大小(8060字节)有一个限制.但是,请检查此链接:

Most likely the last line lacks a \n. Also, there is a limitation in the row size (8060 bytes) in SQL-Server although T-SQL should have mention this. However, check this link:

我的建议:从一行开始,然后开始工作.然后休息.

My advice: Start with one row and get it to work. Then the rest.