Chinaunix's Archiver
论坛
›
数据仓库与数据挖掘
› 触发器更新
liyihongcug
发表于 2011-03-25 19:42
触发器更新
sqlserver的触发器很好用 可以disable enable
create TRIGGER .
ON.
aFTER UPDATE
AS
BEGIN
-- added to prevent extra result sets from interfering with selects
SET NOCOUNT ON;
UPDATE c SET Modified=getdate() WHERE ID IN (SELECT ID FROM Inserted)
页:
[1]
查看完整版本:
触发器更新