use tempdb
BEGIN TRANSACTION
insert into tbl_tmp1(cdate) values('2005-1-2')
insert into tbl_tmp1(cdate) values('2005-1-3')
insert into tbl_tmp1(cdate) values('2005-1-51')
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
END
select * from tbl_tmp1
use tempdb
BEGIN TRANSACTION
insert into tbl_tmp1(cdate) values('2005-1-2')
insert into tbl_tmp1(cdate) values('2005-1-3')
insert into tbl_tmp1(cdate) values('2005-1-51')
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
END
select * from tbl_tmp1