触发器方式:
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
create trigger trg_A
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
on A
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
for update,delete
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
as
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
begin
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
if exists(select 1 from inserted)
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
update B set Name=(select Name from inserted) where Name=(select Name from deleted)
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
else
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
delete B where Name=(select Name from deleted)
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
end
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
go
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
要使用级联性更新和删除,用户可以在Alter TABLE 语句的CONSTRAINT子句中使用ON Update CASCADE 和/或 ON Delete CASCADE 关键字。注意他们都必须是应用于外键的。
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
级联更新和级联删除方式:
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
Alter TABLE [dbo].[T_USERGROUP] ADD
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
CONSTRAINT [FK_T_USERGROUP_T_ACCTTEMPLATE] FOREIGN KEY
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
(
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
[ATNAME]
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
) REFERENCES [dbo].[T_ACCTTEMPLATE] (
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
[ATNAME]
}ƒôî@“Ëù0mwww.izuozhu.cnrDÞ_Ë”
) ON Update CASCADE ON Delete CASCADE
对Sql Server中的表添加级联更新和级联删除的几种方法
最新推荐文章于 2021-05-27 16:00:13 发布