在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
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)
转载于:https://blog.51cto.com/lj1987/736433