CREATE TRIGGER trgIns ON Table1 FOR INSERT AS DECLARE @MaxNum INT SET @MaxNum=(SELECT MAX(num) FROM Table1) UPDATE Table1 SET @MaxNum = Num = @MaxNum+1 FROM Table1 a,inserted b WHERE a.主键=b.主键
--试一下 create trigger yourTrigger on table1 instead of insertdeclare @maxCount int declare @para1 nvarchar(...)select @para1=filedX ... from inserted select @maxCount = max(num) from table1set @maxCount = @maxCount + 1;insert into table1(num, fieldX...) values(@maxCount, @para1...)
creat trigge 触发器名 ON 表 after insert as declare @maxnum int, @numcount int set @numcount = 0 select @maxnum = max(num) +1 from 表select @numcount=count(*) from where num = @maxnumif @numcount>0 删除操作!
什麼意思?
不存在還刪什麼~~?
FOR INSERT
AS
DECLARE @MaxNum INT
SET @MaxNum=(SELECT MAX(num) FROM Table1) UPDATE Table1
SET @MaxNum = Num = @MaxNum+1
FROM Table1 a,inserted b
WHERE a.主键=b.主键
create trigger yourTrigger on table1
instead of insertdeclare @maxCount int
declare @para1 nvarchar(...)select @para1=filedX ... from inserted
select @maxCount = max(num) from table1set @maxCount = @maxCount + 1;insert into table1(num, fieldX...) values(@maxCount, @para1...)
ON 表
after insert
as
declare @maxnum int,
@numcount int
set @numcount = 0
select @maxnum = max(num) +1 from 表select @numcount=count(*) from where num = @maxnumif @numcount>0
删除操作!