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]