在Sybase数据库创建表时,对于自动增长字段的写法示例:

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=1
go

语句更新并插入数据:
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)