SqlServer报错：当 IDENTITY_INSERT 设置为 OFF 时，不能为表 ‘XXX’ 中的标识列插入显式值。

在 insert 数据时报错：

SELECT
t.name AS TableName,
c.name AS ColumnName,
ic.is_identity AS IsIdentityColumn
FROM
sys.tables t
JOIN
sys.columns c ON t.object_id = c.object_id
JOIN
sys.identity_columns ic ON c.object_id = ic.object_id AND c.column_id = ic.column_id
WHERE
ic.is_identity = 1 order by t.name;

 

查询出每个表中的哪些字段的   IDENTITY_INSERT 设置为 OFF