SQL Server triggers cascade inserts, CASCADE updates for tables

First, two tables were created, Test1 and test2, with the expectation that the relevant records of Test2 could be changed at the same time when the test1 was changed. Assume that Test1 is the same as the table structure of Test2, as shown in the following table

Name	Age

The trigger implements a cascade insert:

Create trigger Test3on test1after Insertasinsert into test2 select Name,age from inserted

Triggers implement cascading updates:

Create Trigger Test4on test1after updateas beginupdate test2 Set age = A.age from test2,inserted as a where a.name = Test2 . nameend

Perform:

INSERT into test1 values (' Merle ', ' 99 ');

Output:

SELECT * from Test1, "Merle 99" select * from Test2; "Merle 99"

SQL Server triggers cascade inserts, CASCADE updates for tables