Question

创建一个触发器，使其代替delete语句，从而可以删除表中的内容

Answer 1

CREATE TRIGGER [dbo].[TrigDeleteArea]
ON [dbo].[travel.Area]
AFTER DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @AreaID int
select @AreaID =[area.AreaId] from inserted
delete [travel.line] where [line.AreaId]=@AreaID

-- Insert statements for trigger here

END

GO

Answer 2

这是我们的考试题o(∩_∩)o...：（正确答案）

CREATE OR REPLACE TRIGGER CHECK_TIME
BEFORE
UPDATE OR INSERT OR DELETE
ON EMP
BEGIN
IF (TO_CHAR(SYSDATE,'DY') IN ('SAT','SUN'))
OR TO_CHAR(SYSDATE,'HH24')< '08'
OR TO_CHAR(SYSDATE,'HH24')>='18' THEN
RAISE_APPLICATION_ERROR(-20500,'非法时间修改表错误！');
END IF;
END;

Answer 3

需求不明，打回重写