sqlserver 插入多条怎么期待触发一次触发器
数据库sqlserver,期待Insert多次,在commit时触发一次触发器,实际在commit前就被触发Insert次。怎么能做到在
USE [database01]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER aaaaa_trigger
ON bbb_table
AFTER UPDATE,INSERT
AS
BEGIN
declare @urlStr VARCHAR(255)
SET @urlStr = 'http://192.168.22.22:8080/test/test01';
BEGIN
EXEC mes.P_GET_HttpRequestData @urlStr;
END
END