在数据库中更改日期时自动引发触发器 [英] Raise Triggers automatically when date changed in database

问题描述

大家好，



我的表格中有日期列，我列出了未来的日期，



例如：2013-02-20，



i想在2013-02-20自动提升触发.....



请帮助.....

Hi all,

I have date column in my table in that column i gave future date,

example: 2013-02-20,

i want to raise trigger on 2013-02-20 automatically.....

please help.....

推荐答案

您可以在SQL中的列上触发一个触发器服务器。这些可以是INSERT / UPDAT / DELETE触发器。你还可以实现的下一种触发形式是INSTEAD OF触发器。基于这个问题，你可以选择UPDATE触发器或INSTEAD OF触发器。触发器的语法可以参考： -

触发器 - Sql Server [ ^ ]

You can raise a trigger on column in SQL- Server. These can be INSERT/UPDAT/DELETE triggers. A next form of trigger that you could also implement is the INSTEAD OF trigger.Based on the question, you can either go for an UPDATE trigger or an INSTEAD OF trigger. The syntax of the trigger can be referred at :-
Triggers -- Sql Server[^]

创建一个表更新触发器，如下所示，

Hi,


Create one Table Update Trigger as Follows,

CREATE TRIGGER tr_DelData
ON Employee
FOR Update 
AS
    DECLARE @UpdDate DATETIME = (SELECT <datecolumn> FROM inserted)
    IF DATEDIFF(DAY, @UpdDate , GETDATE()) > 0
    BEGIN
       RAISERROR 50009 'Cannot Insert Future Date for <datecolumn>'
       ROLLBACK TRANSACTION
       RETURN
    END
 GO
</datecolumn></datecolumn>

Regars，

GVPrabu

Regars,
GVPrabu

这篇关于在数据库中更改日期时自动引发触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！