SQL系列学习 存储过程&事物语法
1 /*学习事物基本语法*/ 2 3 /*增加课室名的唯一索引*/ 4 ALTER table class add constraint uni_ClassName unique(name) 5 6 /*创建存储过程,其中增加教师,并增加课室*/ 7 CREATE proc pro_AddClass 8 @className varchar(50), 9 @teacherName varchar(50) 10 as 11 begin 12 declare @teacherid int 13 select @teacherid=id from teacher a where a.name=@teachername 14 15 begin tran 16 IF(@teacherid=0 or @teacherid is null) 17 begin 18 insert into teacher(name) VALUES(@teachername) 19 select @teacherid=IDENT_CURRENT('teacher') 20 end 21 22 insert into class(teacherid,name) VALUES(@teacherid,@classname) 23 24 IF @@error<>0 25 begin 26 rollback tran 27 end 28 else 29 commit tran 30 end 31 32 33 /*执行存储过程,查看结果*/ 34 exec pro_AddClass 'Soft','Teacher Li'
1 exec pro_AddClass 'Math','Teacher Ann'
主要还是记录自己学习的过程,这些基础的知识相信园内已经有很多分享,参考了各位的资料,再作为自学的记录而已,如有差错,请指正