asp 트랜잭션 처리

<SPAN id=tx_marker_caret></SPAN> 'sql2 = "해당 SQL문장(Insert문장임)" 'Set RecordSet = DBconnection.Execute(sql2) con.begintrans con.execute(sql2) if con.errors.count > 0 then con.rollbacktrans response.write "에러다~~~!" else con.committrans response.write "에러는 없구나~~~!" end if IF @@ERROR <> 0 BEGIN SELECT 1 AS A END ELSE BEGIN SELECT 2 AS A END CREATE PROCEDURE 프로시저명 ( 인자값들 ) BEGIN BEGIN DISTRIBUTED TRANSACTION -- INSERT 처리 -- UPDATE 처리 -- DELETE 처리 IF @@error = 0 COMMIT TRAN ELSE ROLLBACK TRAN END GO <textarea>