INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
来源:互联网 发布:mac需要安装flash吗 编辑:程序博客网 时间:2024/06/05 09:40
I ran into the issue on SQL server.:
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
I checked all stored procedures: it is "
SETQUOTED_IDENTIFIEROFF
"
the question: I didn't set the value. the value should be ON by default.
I remembered I run sql script by a sqlcmd.exe , that is the reason.
because the "queoted indentifier " is off by default.
so I rerun the scripts via the following script:
sqlcmd.exe -S "servername" -I -i "sql cript"
The "-I" is to enable the quoted indentifier to ON.
0 0
- INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
- Error: 1934 INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.
- INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that
- [-] Auxiliary failed: Msf::OptionValidateError The following options fa
- The security settings could not be applied to the database because the connection has failed w
- This application has failed to start because the application configuration is incorrect
- “The application has failed to start because its side-by-side configuration is incorrect...”问题
- QT:This application has failed to start because the application configuration is incorrect...
- SET QUOTED_IDENTIFIER
- SET QUOTED_IDENTIFIER
- SET QUOTED_IDENTIFIER
- SET QUOTED_IDENTIFIER
- 解决MVC添加区域(Area)报错failed to render template because of the following errors
- The following packages have unmet dependencies:
- The following packages have unmet dependencies
- The following packages have been kept back:
- the following packages have unmet dependencies
- SET QUOTED_IDENTIFIER, SET ANSI_NULLS
- 数据库工具:MesaSQLite 可视操作
- 关于tomcat下spring无法加载依赖jar中properties文件的原因分析
- JavaScript原型继承工作原理
- tomcat中内存设置
- Java Base64加密、解密原理Java代码
- INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
- android Bitmap用法总结
- 2015年最具潜力的十大微信公众号
- Android WebView 闪屏问题
- 设置SublimeText在浏览器里查看
- MySQL数据库备份的命令
- WdatePicker日历控件使用方法
- Welcome to STXXL
- oracle 索引压缩