create trigger tri_reader
on Reader after insert
as
begin
SET NOCOUNT ON;
if EXISTS(select 1 from INSERTED where NotificationType is null)
begin
update Reader set [NotificationType]=1
from INSERTED as T where Reader.id=T.id and T.NotificationType is null
end
end
go
sqlserver 触发器在数据插入时为空的数据赋值
最新推荐文章于 2024-01-19 10:08:08 发布