SQL 语句中事物的使用方法

begin try
begin transaction 
insert into shiwu (asd) values ('aasdasda'); 
commit transaction 
end try 
begin catch 
select ERROR_NUMBER() as errornumber 
rollback transaction 
end catch