SQL
Skye_H
这个作者很懒,什么都没留下…
展开
-
Error evaluating expression 'category.id != null and category.id != '''. Cause: org.apache.ibatis.og
SQL语句中出现 Error evaluating expression ‘category.id != null and category.id != ”’. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, “id”) 解决方式:...原创 2018-09-11 11:30:34 · 25155 阅读 · 1 评论 -
A query was run and no Result Maps were found for the Mapped Statement XXX
错误描述:A query was run and no Result Maps were found for the Mapped Statement ‘com.mdsw.dses.statistics.dao.XXXMapper.XXX’. It’s likely that neither a Result Type nor a Result Map was specified.错误原因:...原创 2018-11-21 16:49:15 · 345 阅读 · 0 评论 -
sql server遇到以零作除数错误
错误描述:遇到以零作除数错误错误原因:没有判断除数为0的情况解决方式:判断除数是否为0(demo为除数)NULLIF(demo,0)原创 2018-12-04 16:18:04 · 1204 阅读 · 0 评论 -
禁止在 .NET Framework 中执行用户代码。启用 "clr enabled" 配置选项
错误描述:解决方法:对应数据库执行sqlexec sp_configure 'show advanced options', '1';goreconfigure;goexec sp_configure 'clr enabled', '1'goreconfigure;exec sp_configure 'show advanced options', '1';go...原创 2019-10-10 11:51:42 · 289 阅读 · 0 评论