摘要: Rolling Back Changers to a MarkerCreate a marker in the current transaction by using the SAVEPOINT statement.Roll back to that marker by using the ROLLBACK TO SAVEPOINT statement.UPDATE ...SAVEPOINT update_done;INSERT ...ROLLBACK TO update_done;Implict Transaction ProcessingAn automatic commit occur 阅读全文
posted @ 2013-04-17 13:16 ArcerZhang 阅读(214) 评论(1) 推荐(0) 编辑
摘要: Changing Data in a TableUPDATE Statement SyntaxModify existing values in a table with the UPDATE statementUPDAE tableSET column = value [,column = value,...][WHERE condition];Update more than one row at a time(if required)Updating Rows in a TableValuesfor a specific row or rows are modified if you s 阅读全文
posted @ 2013-04-17 11:09 ArcerZhang 阅读(126) 评论(0) 推荐(0) 编辑