【2018-01-19】Sql Server-视图，事务
标签：bsp span end pre 出现 rom 事务 user begin
【2018-01-19】Sql Server-视图，事务
--视图增删改操作不影响基础表
----视图不允许出现重复列
create view haha--创建视图
as
select student.*,Score.Cno,Score.Degree from student,score where student.Sno=Score.Sno
select * from haha
----事务
begin tran
insert into users values(‘赵四‘,‘c002‘)
insert into users values(‘赵五‘,‘c001‘)
if @@error>0
begin
rollback tran;
end
begin
commit tran;
end
select * from users;