transaction2.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 17 行

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