Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
Copy Code code as follows:
Create Trigger Tgname
If Update (recommend)
Update TB Set commenddate= (GETDATE ()) from TB inner join inserted on Tb.vlistid=inserted.vlistid
Recommend represents the field being updated.
The key is the inserted table
Two special tables are used in trigger statements: Deleted tables and inserted tables.
The Deleted table is used to store a copy of the rows affected by the DELETE and UPDATE statements. When the delete or UPDATE statement is executed, the row is removed from the trigger table and transferred to the deleted table. Deleted tables and trigger tables usually do not have the same rows.
The Inserted table is used to store a copy of the rows affected by the INSERT and UPDATE statements. In one insert or update transaction, new rows are added to both the inserted table and the trigger table. The row in the Inserted table is a copy of the new row in the trigger table.
1. Inserting operation (insert) Inserted table has data, deleted table has no data
2. Delete operation (delete) Inserted table has no data, deleted table has data
3. Update operation (updated) Inserted table has data (new data), deleted table has data (old data)
Why do you sleep before you die?
This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or
reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or
complaint, to email@example.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
and provide relevant evidence. A staff member will contact you within 5 working days.