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

Purpose: update the fields in a table, automatically trigger the trigger, the trigger will change the value of the added field, and then determine which tables have been update according to the value of the added field before and after the change, and add filters at the business level to filter those updated tables

one。 Add fields to the table and add default values

Alter table Project add IsSys int default (1)

two。 Change the default value

Update Project set IsSys='1'

Three. Create trigger

CREATE TRIGGER ProjectDATAUpdate

ON Project

For UPDATE

AS

BEGIN

If not update (IsSys)

Update Project set IsSys='0' from Inserted a where Project.id=a.id

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.