创建insert插入类型触发器
--创建insert插入类型触发器
if (object_id('tgr_g_ajz_insert', 'tr') is not null)
drop trigger tgr_g_ajz_insert
go
create trigger tgr_g_ajz_insert
on transfer.dbo.g_ajz
for insert --插入触发
as
--定义变量
declare @id uniqueidentifier;
--在inserted表中查询已经插入记录信息
select @id = id from inserted;
update transfer.dbo.g_ajz set number = (select MAX(number)+1 from transfer.dbo.g_ajz) where id = @id
print '更新number成功!';
go
参考:
sql官方文档:https://docs.microsoft.com/zh-cn/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15#examples