Create trigger Sql server

Question

Create trigger Sql server

Navigation

#1 by (1 votes)

0

I have this statement to import data to the test table, what I need is to create a trigger.

BULK
INSERT PRUEBA
FROM 'C:\prueba.CSV'
WITH
(
-- seteamos el separador de campos
FIELDTERMINATOR = ',',
--seteamos el separador de registro
ROWTERMINATOR = '\n'
);
GO

sql sql-server

asked by R.Priego 27.12.2016 в 11:49

source

1 answer

Google charts: error All series on a given axis must be of the same data type add class css to ng-mouseenter in angularjs

score 1 · Answer 1

The next trigger (named NameTrigger) will be executed later (AFTER) of each insert in the TEST table, where I put the PRINT you should code the function you want the trigger to perform, if you need more help, expand the info of the ask.

 CREATE TRIGGER NombreTrigger ON PRUEBA
    AFTER INSERT 
    AS
    PRINT 'Se inserto una fila';

EDIT: As comrade @Lamak says, you should add the FIRE_TRIGGERS argument to your BULK INSERT

BULK
INSERT PRUEBA
FROM 'C:\prueba.CSV'
WITH
(
-- seteamos el separador de campos
FIELDTERMINATOR = ',',
--seteamos el separador de registro
ROWTERMINATOR = '\n',
FIRE_TRIGGERS
);
GO