【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“345.sql”一文,供大家参考学习!
use db_
sql go
create trigger stu_instead
on stu_view
instead of insert as
begin
declare @学生编号 varchar(2)
select @学生编号 = substring(学生编号,1,2)
from inserted
if @学生编号 = '01'
begin
insert into tb_stu0117 select 学生编号,,性别 from inserted
return
end
if @学生编号 ='02'
begin
insert into tb_stu0217 select 学生编号,,性别 from inserted
return
end
if @学生编号 = '03'
begin
insert into tb_stu0317 select 学生编号,,性别 from inserted
end
else
begin
rollback transaction
print('插入的学生信息不正确,请确认学生编号后重新插入')
end
end
insert into stu_view values ('02d0420','王名','男')