34,590
社区成员
发帖
与我相关
我的任务
分享
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.主键