触发器

来源：互联网发布：韩剧和真实的韩国知乎编辑：程序博客网时间：2024/05/22 17:50

delete如果另一张还在用则删除失败触发器

USE [homework]GO/****** Object:  Trigger [dbo].[del]    Script Date: 2016/11/24 21:17:02 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER trigger [dbo].[del]on [dbo].[Company]instead of  Deleteasbegin if not exists(select * from [dbo].[User], deleted where [dbo].[User].[CompanyId] = deleted.Id)        delete from Company where Company.Id in (select Id from deleted)end

自动更新

USE [homework]GO/****** Object:  Trigger [dbo].[triup]    Script Date: 2016/11/24 21:27:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER trigger [dbo].[triup]on [dbo].[Company]after updateasbegin   update [dbo].[User] set  [dbo].[User].CompanyName=(select Name from Company where [dbo].[User].CompanyId=[Company].Id)end

0 0