Sql server 事务回滚

最新推荐文章于 2024-08-09 04:14:35 发布

原创最新推荐文章于 2024-08-09 04:14:35 发布 · 613 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #insert #table #database #null #object

Sql Server 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了SQL数据库操作，包括创建、删除数据库，表结构设计，数据插入及事务管理流程，通过实例演示确保数据操作的可靠性和一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

if exists (select * from sys.databases where name='TestDB')
drop database TestDB;
create database TestDB;

use TestDB;

if OBJECT_ID('department','U') is not null
drop table department
create table department
(
id int primary key identity(1,1),
name varchar(20) not null,
num varchar(50) not null
)

if OBJECT_ID('employee','U') is not null
drop table employee;
create table employee
(
id int primary key identity(1,1) ,
name nvarchar(30) not null,
departmentId int foreign key references department(id) not null
)

insert into employee(name)values('zhangsan')

select * from employee;
select * from department;select * from employee;
select * from department;

begin transaction
declare @errorSum int
set @errorSum = 0
insert into department(name,num)
values('软件一部','001')
insert into employee(name,departmentId)
values ('lishi','1')
set @errorSum =@errorSum + @@error --累加错误到变量@errorSum中
if @errorSum <>0
begin
print '------------------回滚事务--------------------------'
rollback transaction
end
else
begin
print '------------------提交事务---------------------------'
commit transaction
end