Shulou(Shulou.com)06/01 Report--

-- create a trigger USE [TEST] GO-- for a table There are multiple triggers, one of which is the case of INSTEAD OF. Other triggers will lose their function. CREATE trigger _ Name-- name-- ALTER modifies on COPTD-- Table name for INSERT,UPDATE,DELETE-- INSERT,UPDATE corresponds to Inserted table DELETE corresponds to deleted table-- Instead Of INSERT-- insert data into Inserted table as BEGIN DECLARE @ TD001 char (4) SELECT @ TD001 = TD001 from Inserted-- assign if exists (select UDF11 from INVMB where MB001 = @ TD001 and UDF11 ='N') BEGIN INSERT INTO COPTDLog (TD001) VALUES (@ TD001) END END-- -

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.