日期:2014-05-17 浏览次数:20485 次
CREATE TRIGGER tr_InsBBTB
ON dbo.aaTB
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
INSERT INTO dbo.bbTB
( id, UserID, UserName )
SELECT id, UserID, UserName FROM inserted
END
GO
exec master..xp_cmdshell '[路径]\[文件名].bat'