INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that

来源:互联网 发布:linux从u盘复制文件 编辑:程序博客网 时间:2024/05/16 05:45

执行加字段的语句报错:

INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Invalid column name 'ProductPropertyCode'.

出错原因:ANSI_PADDING为ON;

解决办法:设为OFF

SET ANSI_PADDING OFF;

0 0