- 博客(3)
- 资源 (8)
- 收藏
- 关注
原创 db2 union 分页问题
对于db2 union 分页sql的写法如:最终sql:sql="select * from (select t.INSTANCEID as instanceid,a.WORKSHEETID as worksheetid,a.WORKSHEETTITLE as worksheettitle, a.CREATOR ascreator,t.WFSIGN as wfsign,t.
2012-01-11 15:24:12 654
原创 Null value was assigned to a property of primitive type setter问题分析与解决
org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.itsm.bpm.cmdb.designmodel.model.CiConfigdisp.ordernum org.hibernate.property.BasicPr
2012-02-06 10:53:21 3020
原创 db2 COALESCE 函数的用法
select * from CM_CITEMP t where t.EFFECTIVE='1' and t.CHOOSEFLAG='1' and COALESCE(t.SUBMITFLAG,'') ='1' 如果字段可以为空的字符串类型 设置成COALESCE(t.SUBMITFLAG,'') !=’1‘这样就可以查询出 SUBMITFLAG 字段为空的记录。而这样t.SUBMITF
2012-02-03 14:00:03 2033
虚拟机8.0.1注册机
2013-12-04
liunx 搭建svn 所需下载源码
2012-10-31
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人