sqlserver在更新任意字段时设置当前时间戳(类似mysql中的ON UPDATE CURRENT_TIMESTAMP)
1.建表create table tUser( id int primary key identity, name varchar(20), password varchar(50), updatetime datetime default GETDATE());2.创建触发器create trigger mytrigger ON tUserafter INSERT ,updateASbegin update tUser set updatetime = GETDA
原创
2022-05-13 16:06:31 ·
2989 阅读 ·
0 评论