SQL Server 2012数据库原理与应用第十讲 存储过程、触发器和游标.pptVIP

创建学生选课触发器（Delete） Create Trigger T_ElectCourseResult_Delete On ElectCourseResult After Delete AS Begin Update TeacherCourseInfo Set RemainPersonCount=RemainPersonCount-1 From Deleted D,TeacherCourseInfo T Where T.TeacherNo=D.TeacherNo And T.CourseID=D.CourseID End 查看触发器的相关信息 Sp_helptrigger table_name[,type] Exec sp_helptrigger ClassInfo,update Exec sp_helptext T_ClassInfo Exec sp_depends T_ClassInfo 10.3 游标 可以把Cursor看成是一个用来保存“数据集”（多条记录）的对象 因SELECT语句查询的结果，是直接返回前端应用程序中，而无法在SQL程序中一笔一笔地处理 可以将挑选出来的结果先放入Cursor中，然后利用循环将每一条记录从Cursor中取出来处理 10.3.1 游标简介 SELECT、UPDATE、DELETE等语句都是属于数据集式的操作，即一次可针对多条记录进行处理 使用以记录为处理单位的Cursor可一条一条单独处理数据 Cursor主要使用于SQL批、存储过程或触发器中 10.3.2 声明游标 DECLARE CURSOR 定义 Transact-SQL 服务器游标的特性 游标的滚动行为和用于生成游标对其进行操作的结果集的查询。 SQL-92 语法 DECLARE cursor_name [ INSENSITIVE ] [ SCROLL ] CURSOR FOR select_statement [ FOR { READ ONLY | UPDATE [ OF column_name [ ,...n ] ] } ] 10-* Copyright ? SWFU-CISC, 2016. All rights reserved. SQL Server 2012 数据库原理及应用 Made by Ning Lu Database Principle Application 10 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