/* INSCRIRE LA DATE DU JOUR LORS DE LA MODIFICATION D'UN TEXTE */
CREATE TRIGGER maj_texte ON dbo.TEXTES
FOR INSERT, UPDATE, DELETE
as
DECLARE @ident_text INT
SELECT @ident_text = ID_TEXTE
FROM deleted TEXTES
UPDATE TEXTES
SET DATE_JOUR_USAGER = CURRENT_TIMESTAMP
FROM [TEXTES]
where ID_TEXTE = @ident_text
/* INSCRIRE LES DONNÉES HISTORIQUES DANS LA TABLE DE CONTRÔLE DE TEXTE */
INSERT INTO [CONTROLE_TEXTE]
(ID_TEXTE, STATUT, DATE_CREATION, DATE_MODIFICATION,DATE_MISE_A_JOUR,
DATE_TOMBER, DATE_EXPIRATION, DATE_JOUR_USAGER, TITRE, SOUS_TITRE,
INTRODUCTION, TEXTE, AUTEUR, VERROUILLER, TEMPLATE, ID_LANGUE, ID_IMAGE,
ID_SECTION_SITE)
SELECT ID_TEXTE, STATUT, DATE_CREATION, DATE_MODIFICATION, DATE_MISE_A_JOUR,
DATE_TOMBER, DATE_EXPIRATION, DATE_JOUR_USAGER, TITRE, SOUS_TITRE,
INTRODUCTION, TEXTE, AUTEUR, VERROUILLER, TEMPLATE, ID_LANGUE, ID_IMAGE,
ID_SECTION_SITE
FROM inserted TEXTES
"Fernand St-Georges" <fe****************@videotron.ca> a écrit dans le
message de news: Sw******************@weber.videotron.net...
How to build a TRIGGER that copies, all the time, the data from the table
on which the transaction occurs to the historical table?
thanks
Fernand
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 2004-04-15
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 2004-04-15