在Sybase數(shù)據(jù)庫創(chuàng)建表時，對于自動增長字段的寫法示例：
drop table BFCRM.HYK_SJJL
GO
create table BFCRM.HYK_SJJL(
JLBH????? int???????? identity,
HYK_NO?? char(12)???? not null,
CLSJ?? datetime??????? not null,
HYKTYPE_OLD smallint?? not null,
HYKTYPE_NEW smallint?? not null,
constraint PK_HYK_SJJL PRIMARY KEY CLUSTERED (JLBH)
)
with identity_gap=1go

語句更新并插入數(shù)據(jù):
declare @HYTYPE_OLD int
declare @HYTYPE_NEW int
declare @HYNO char(8)
select @HYTYPE_OLD=101
select @HYTYPE_NEW=104
select @HYNO='66600835'
update BFCRM.HYK_HYXX set HYKTYPE=@HYTYPE_NEW where HYKTYPE=@HYTYPE_OLD and HYK_NO=@HYNO

insert into BFCRM.HYK_SJJL(HYK_NO,CLSJ,HYKTYPE_OLD,HYKTYPE_NEW) values(@HYNO,getdate(),@HYTYPE_OLD,@HYTYPE_NEW)

轉(zhuǎn)載于:https://blog.51cto.com/lj1987/736433

總結(jié)

以上是生活随笔為你收集整理的sybase自增与插入的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。