SQL Server 2012数据库原理与应用第十二讲 数据库备份与恢复.pptVIP

12-* Copyright ? SWFU-CISC, 2016. All rights reserved. SQL Server 2012 数据库原理及应用 Made by Ning Lu Database Principle Application 12 Copyright ? SWFU-CISC, 2016. All rights reserved. SQL Server 2012 数据库原理及应用 Made by Ning Lu Database Principle Application Schedule: Timing Topic 40 minutes Lecture 25 minutes Practice 65 minutes Total Lesson Aim To extract data from the database, you need to use the structured query language (SQL) SELECT statement. You may need to restrict the columns that are displayed. This lesson describes all the SQL statements needed to perform these actions.You may want to create SELECT statements that can be used more than once. This lesson also covers the iSQL*Plus environment where you execute SQL statements. Note: iSQL*Plus is new in the Oracle9i product. It is a browser environment where you execute SQL commands. In prior releases of Oracle, SQL*Plus was the default environment where you executed SQL commands. SQL*Plus is still available and is described in Appendix C. 第十二讲 数据库备份与恢复 教学内容 事务 事务ACID属性 事务类型 锁 锁概念 并发性 备份与恢复 备份 恢复 实用SQL Server操作 生成SQL脚本 导出网页 关系图 实用DTS 用户李刚将中行50元转入交行 中行(China_Bank) 交行(Traffic_Bank) C_Card_ID C_Money LG001 150 T_Card_ID T_Money LG111 200 Update China_Bank Set C_Money=C_Money-50 Where C_Card_ID=LG001 Update Traffic_Bank Set T_Money=T_Money+50 Where T_Card_ID=LG111 创建示例表 Create Table China_Bank( C_Card_ID Varchar(10) Primary Key, C_Money Money ) Create Table Traffic_Bank( T_Card_ID Varchar(10) Primary Key, T_Money Money ) Insert Into China_Bank Values(LG001,150) Insert Into Traffic_Bank Values(LG111,200) 事务概念 事务 作为单个逻辑工作单元执行的一系列操作 一个逻辑工作单元必须有四个属性（ACID属性） ACID 原子性 一致性 隔离性 持久性 事务的属性（ACID） 原子性(Atomicity) 事务必须是原子工作单元 对于其数据修改，要么全都执行，要么全都不执行 一致性(Consistency) 事务在完成时，必须使所有的数据都保持一致状态 隔离性(Isolation) 由并发事务所作的修改必须与任何其它并发事务所作的修改隔离 持久性(Durability) 事务完成之后，它对于系统的影响是永久性的 三种事务类型 显式事务 在自动提交模式下以Begin Transaction开始一个