1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| ========
mon triggers
========
create trigger insertPrg on Programme for insert
as
exec InsertActionProgramme
==========
ma procedure InsertActionProgramme
==========
USE [SauvegareFichier]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[InsertActionProgramme]
AS
declare @val datetime
select @val= DateHeure_Courante FROM V_DateHeure_Courante
SET NOCOUNT ON;
INSERT INTO [SauvegareFichier].[dbo].[ActionFichier]
([type_action],date_action)
VALUES
('Insert', @val ); |
Partager