transaction2.sql

在学习SQL Server过程中整理的T-SQL语句

declare @tran_name varchar(20)

set @tran_name ='mytran1'

begin transaction @tran_name
go

use test
go

update stucopy
   set sname='0aa'
   where sno='001'
go

commit transaction @tran_name
go