SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `dataex_trigger_record`;
CREATE TABLE `dataex_trigger_record` (
`ROWGUID` varchar(50) NOT NULL,
`TABLENAME` varchar(50) DEFAULT NULL,
`COLUMNNAME` varchar(50) DEFAULT NULL,
`COLUMNVALUE` varchar(100) NOT NULL,
`INSERTDATE` date DEFAULT NULL,
`OPERATETYPE` varchar(10) DEFAULT NULL,
`SYNC_DATE` date DEFAULT NULL,
`SYNC_SIGN` varchar(10) DEFAULT NULL,
`SYNC_ERROR_DESC` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`ROWGUID`)
) ;
第二步:触发器
– sqlserver
CREATE TRIGGER E_DATA_FROM_A ON data_from FOR INSERT AS
BEGIN
INSERT INTO DATAEX_TRIGGER_RECORD (
ROWGUID,
TABLENAME,
COLUMNNAME,
Columnvalue,
INSERTDATE,
Operatetype
)(
SELECT
newid (),
'data_from',
'id