表的结构如下
CREATE TABLE TDrpYWFDayRateHY(
cName varchar(50) not null, --说明
iStartDays int not null, --起始天数
iEndDays int null, --结束天数, 不可更改
nDayRate numeric(8,4) not null, --百分率
cMemo varchar(50) null,
iAutoID INT NOT NULL IDENTITY)
增加一行后,自动将增加的行的iStartDays的值写入上一行的 iEndDays
create trigger tName on TDrpYWFDayRateHY
for insert
as
declare @iEndDays int,@iAutoID int
select @iEndDays = inserted.iStartDays from inserted
select @iAutoID = inserted.iAutoID from inserted
update TDrpYWFDayRateHY set iEndDays = @iEndDays where iAutoID = (select top 1 iAutoID from TDrpYWFDayRateHY where iAutoID < @iAutoID ORDER BY iAutoID DESC)