2013年4月17日
Chapter 09-Manipulation Data - 03
摘要： 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 阅读(221) 评论(1) 推荐(0)
Chapter 09-Manipulation Data - 02
摘要： 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 阅读(140) 评论(0) 推荐(0)