SqlServer 仅当使用了列列表并且 IDENTITY_INSERT 为 ON 时
出现此问题时,解决办法
--必须带上字段名,不然还是报错
set identity_insert MES_IQC_BINFILES on INSERT INTO MES_IQC_BINFILES(id, usefor, usefor_id, filename, filetype, filesize, file_content) SELECT id, usefor, usefor_id, filename, filetype, filesize, file_content FROM [172.30.1.93].[WEB].DBO.[m_binfiles]