Use Tempdb
Begin Transaction Insert INTO TBL_TMP1 (CDATE) VALUES ('2005-1-2') INSERT INTO TBL_TMP1 (CDATE) VALUES ('2005-1-3') INTO TBL_TMP1 (CDATE) VALUES ('2005-1-51') IF (@@ Error <> 0) Begin Rollback Transaction End
SELECT * from TBL_TMP1
