T-SQL 触发器的使用

碧山云游

于 2021-06-24 14:09:10 发布

阅读量155

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL与数据库

本文链接：https://blog.youkuaiyun.com/qq_41617901/article/details/118187029

SQL与数据库专栏收录该内容

39 篇文章

订阅专栏

create trigger tri_InsertPeople on People
after insert
as
if not exists(select * from Department where DepartmentId = 
(select DepartmentId from inserted))
		BEGIN
          print '不存在'
					insert into Department(DepartmentId,DepartmentName)
					values((select DepartmentId from inserted),'新部门')
		END
      ELSE PRINT '存在'
go

drop  trigger  tri_InsertPeople

insert People(DepartmentId,PeopleName,PeopleSex,PeoplePhone,RankId,PeopleBirth,PeopleSalary)
values('1','赵云','男','13854587457','1','2020-7-7',1000)

SELECT *  from Department where DepartmentId='009'
DELETE  People where  DepartmentId='009'