27,579
社区成员
发帖
与我相关
我的任务
分享
alter TRIGGER [dbo].[tr_Insert2]
ON [dbo].[t1]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- if @@rowcount = 0 --如果影响的行数为 0,则结束触发器运行,避免占用资源
-- return
-- Insert statements for trigger here
INSERT INTO [abc].[dbo].[t2]
([AppID]
,[AppStatus])
VALUES
(
(select max(appid) from inserted)
,0);
-- Insert statements for trigger here
INSERT INTO [abc].[M].[t2]
([AppID]
,[AppStatus])
VALUES
(
(select max(appid) from inserted)
,0)
end