CREATE TRIGGER Delete ON [dbo].[ManufacturalDayReport] Instead Of INSERT //我是这样写的 AS Delete From ManufacturalDayReport go//=====================================CREATE TRIGGER WriteTime ON [dbo].[ManufacturalDayReport] FOR INSERT //我是这样写的 AS Update ManufacturalDayReport Set DateTime =GetDate() go// 最后结果是 执行了第一个触发器后没有执行第二个触发器 为什么?
替代触发器 CREATE TRIGGER 名 on 表 INSTEAD OF INSERT AS BEGIN INSERT INTO 表 SELECT name1,name1 FROM inserted END
CREATE TRIGGER Delete ON [dbo].[ManufacturalDayReport] Instead Of INSERT //我是这样写的 AS Delete From ManufacturalDayReport insert ManufacturalDayReport select * from inserted Update ManufacturalDayReport Set DateTime =GetDate() go
开始要插入数据必须清空原有的数据 插入完后就要求更新数据 就象DELPHI的事件样 //===================================== CREATE TRIGGER Delete ON [dbo].[ManufacturalDayReport] Instead Of INSERT //我是这样写的 AS Delete From ManufacturalDayReport go//=====================================CREATE TRIGGER WriteTime ON [dbo].[ManufacturalDayReport] FOR INSERT //我是这样写的 AS Update ManufacturalDayReport Set DateTime =GetDate() go// 最后结果是 执行了第一个触发器后没有执行第二个触发器 为什么?
Instead Of INSERT //我是这样写的
AS
Delete
From ManufacturalDayReport
go//=====================================CREATE TRIGGER WriteTime ON [dbo].[ManufacturalDayReport]
FOR INSERT //我是这样写的
AS
Update ManufacturalDayReport
Set DateTime =GetDate()
go// 最后结果是 执行了第一个触发器后没有执行第二个触发器 为什么?
CREATE TRIGGER 名 on 表
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO 表
SELECT name1,name1
FROM inserted
END
右键你的数据库-->属性-->选项-->递归触发器-->打勾
Instead Of INSERT //我是这样写的
AS
Delete From ManufacturalDayReport
insert ManufacturalDayReport select * from inserted
Update ManufacturalDayReport Set DateTime =GetDate()
go
插入完后就要求更新数据
就象DELPHI的事件样
//=====================================
CREATE TRIGGER Delete ON [dbo].[ManufacturalDayReport]
Instead Of INSERT //我是这样写的
AS
Delete
From ManufacturalDayReport
go//=====================================CREATE TRIGGER WriteTime ON [dbo].[ManufacturalDayReport]
FOR INSERT //我是这样写的
AS
Update ManufacturalDayReport
Set DateTime =GetDate()
go// 最后结果是 执行了第一个触发器后没有执行第二个触发器 为什么?