I have a table in SQL server 2005. I would like to have the following scenario:
Whenever a new row is inserted into this table I would like to update another existing table. One column of this table is to be updated with the value inserted into one of the original table's columns.
Table in which rows are inserted:
Existing table to update:
When a new row is added into the Status table (signalling status change), I would like the matching record's Status field in the Customer table to take on the value inserted in the Status table.
I would appreciate if you could post an appropriate T-SQL statement to enter into the trigger definition.
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…