2012年3月21日
DB2命令小计
摘要： //创建一个sequenceCREATE SEQUENCE business_SEQ AS bigint START WITH 1 INCREMENT BY 1 NO MAXVALUE CYCLE CACHE 20;//使用序列号sequencenext value FOR BUSINESS_SEQ//插入记录INSERT INTO BUSINESS (BUSINESSID,CREATEDATE,UPDATED) VALUES(next value FOR BUSINESS_SEQ,CURRENT TIMESTAMP,CU... 阅读全文
posted @ 2012-03-21 09:18 Horrison 阅读(396) 评论(0) 推荐(0)