大三 sql 課后習(xí)習(xí)題答案

1、第二章3.上機練習(xí)題02 程序代碼如下：CREATE DATABASE STUDENT1ON PRIMARY(NAME= STUDENT1_data,FILENAME='E:DATA',SIZE=3,MAXSIZE=unlimited,FILEGROWTH=15%)LOG ON(NAME= STUDENT1_log,FILENAME='E:DATA',SIZE=2,MAXSIZE=30,FILEGROWTH=2)03 程序代碼如下：create database studentson primary(name=students1,filename='E:

2、DATA',size=5,maxsize=75,filegrowth=10%),(name= students12,filename='E:DATA',size=10,maxsize=75,filegrowth=1)log on (name=studentslog1,filename='E:DATA',size=5,maxsize=30,filegrowth=1),(name=studentslog2,filename='E:DATA',size=5,maxsize=30,filegrowth=1)第三章：3 上機練習(xí)題01 程序代碼如下

3、：- 創(chuàng)建表book的Transact-SQL語句：USE test01GOCREATE TABLE book(book_id nchar(6) NOT NULL,book_name nchar(30) NULL,price numeric(10, 2) NULL, CONSTRAINT PK_book PRIMARY KEY CLUSTERED ( book_id ASC ) ) ON PRIMARY- 創(chuàng)建表uthor的Transact-SQL語句：CREATE TABLE (anthor_name nchar(4) NOT NULL,book_id nchar(6) NOT NULL,a

4、ddress nchar(30) NOT NULL) ON PRIMARY- 設(shè)置book中的book_id為主鍵，author表中的book_id為外鍵ALTER TABLE WITH CHECK ADD CONSTRAINT FK_ book_author FOREIGN KEY(book_id)REFERENCES (book_id)02 程序代碼如下：-利用Transact-SQL語句創(chuàng)建表booksales的代碼。USE test01GOCREATE TABLE booksales(book_id nchar(6) NOT NULL,sellnum int NOT NULL,sell

5、date datetime NOT NULL) ON PRIMARY-利用insert語句為表booksales添加數(shù)據(jù)：INSERT INTO booksales VALUES ('m00011',7,20/12/2008)INSERT INTO booksales(book_id,sellnum,selldate) VALUES ('m00017',3,17/11/2008 ) -利用update語句為表booksales更新數(shù)據(jù)：UPDATE booksales SET sellnum =11WHERE book_id ='m00011'-

6、利用delete語句刪除表booksales的數(shù)據(jù)：DELETE FROM booksales WHERE book_id ='m00011'03 程序代碼如下：USE test01GOCREATE RULE sellnum_rule AS sellnum >=0EXEC sp_bindrule 'sellnum_rule',''04 程序代碼如下：-刪除年以前的數(shù)據(jù)DELETE FROM booksales WHERE selldate < '1/1/2009'-刪除所有數(shù)據(jù)Truncate Table booksa

7、les第四章3 上機練習(xí)題01 程序代碼如下：DECLARE bookname nchar(16)set bookname = 'SQL Server數(shù)據(jù)庫編程'02 程序代碼如下：USE test01GOSET NOCOUNT ONDECLARE startdate datetime,enddate datetimeSET startdate = '1/7/2008 12:12 AM'SET enddate = '11/10/2009 12:00 AM'SELECT DATEDIFF(year,startdate,enddate)SELECT

8、DATEDIFF(month,startdate,enddate)SELECT DATEDIFF(day,startdate,enddate)SELECT DATEDIFF(minute,startdate,'1/8/2007 12:17 AM')SELECT DATEDIFF(minute,startdate,GETDATE()SET NOCOUNT OFFGO03 程序代碼如下：DECLARE count INT,SUM INTSET count =51SET SUM=0WHILE count <=100 BEGINIF (CEILING(count/<= FL

9、OOR(count/) BEGIN SET SUM = SUM + count END SET count = count+2 ENDPRINT '50到之間的所有能被整除的奇數(shù)之和'+CAST(SUM AS NCHAR(4)第五章3 上機練習(xí)題01 程序代碼如下：-查詢course表中的所有記錄。use teachinggoselect * from coursego02 程序代碼如下：-查詢student表中的女生的人數(shù)。use teachinggoselect * from studentwhere sex='女'go03 程序代碼如下：-查詢teache

10、r表中每一位教授的教師號、姓名和專業(yè)名稱。use teachinggoselect teacherno,tname,major from teacherwhere prof='教授'go04 程序代碼如下：-按性別分組，求出student表中的每組學(xué)生的平均年齡。use teachinggoselect sex as '學(xué)生性別' , avg(DATEDIFF(year,birthday,getdate() as '平均年齡' from studentgroup by sexgo05 程序代碼如下：-利用現(xiàn)有的表生成新表，新表中包括學(xué)號、學(xué)生姓名

11、、課程號和總評成績。-其中：總評成績=final*+usually*use teachinggoselect ,final*+usually* as '總評'into stu_sorsefrom student,scorewhere =goselect * from stu_sorsego06 程序代碼如下：-統(tǒng)計每個學(xué)生的期末成績平均分。use teachinggoselect studentno,sname,avg(總評)from stu_sorsegroup by studentno,snamego07 程序代碼如下：- 輸出student表中年齡最大的男生的所有信息。u

12、se teachinggoselect * from studentwhere birthday= (select min(birthday) from student)go08 程序代碼如下：-查詢teacher表中沒有職稱的職工的教師號、姓名、專業(yè)和部門。use teachinggoselect teacherno,tname,major,departmentfrom teacherwhere prof is NULLgo第六章3 上機練習(xí)題01 程序代碼如下：-查詢每一位教授的教師號、姓名和講授的課程名稱。use teachinggoselect ,tname,major,from te

13、acher,course,teach_classwhere prof ='教授' and = and =go02 程序代碼如下：-利用現(xiàn)有的表生成新表，新表中包括學(xué)號、學(xué)生姓名、課程名稱和總評成績。-其中：總評成績=final*+usually*use teachinggoselect DISTINCT ,*+* as '總評'into stu_coursefrom student,course,teach_class,scorewhere = and =go03 程序代碼如下：-統(tǒng)計每個學(xué)生的期末成績高于分的課程門數(shù)。use teachinggoselect

14、,count(*) as '課程門數(shù)'from student,scorewhere > 75 and = group by ,go 04 程序代碼如下：-輸出student表中年齡大于女生平均年齡的男生的所有信息。use teachinggoselect * from studentwhere sex= '男' and DATEDIFF(year,birthday,getdate() > ( select avg(DATEDIFF(year,birthday,getdate() from student where sex= '女'

15、) go 05 程序代碼如下：-計算每個學(xué)生獲得的學(xué)分。use teachinggoselect ,sum(credit)from student INNER JOIN score ON = INNER JOIN course ON =where >60group by , go 06 程序代碼如下：-獲取入學(xué)時間在年到年的所有學(xué)生中入學(xué)年齡小于歲的學(xué)號、姓名及所修課程的課程名稱。use teachinggoselect ,from student inner join stu_course on = where (substring,1,2)='08' and (dat

16、ediff(year,birthday,'2008-01-01')<19) or(substring,1,2)='09' and (datediff(year,birthday,'2009-01-01')<19)go 07 程序代碼如下：-查詢級學(xué)生的學(xué)號、姓名、課程名及學(xué)分。use teachinggoselect ,from student inner join stu_course on = where substring,1,2)='09' go08 程序代碼如下：-查詢選修課程的少于門、或期末成績含有分以下課

17、程的學(xué)生的學(xué)號、姓名、電話和Email。use teachinggoselect studentno,count(*) as 'countNUM' into count1from scoregroup by studentno GOselect ,sname,phone,Emailfrom student inner join score on = inner join count1 on = where <60 and countNUM<3 go第七章 3 上機題練習(xí)01 程序代碼如下：-在course表的cname列上創(chuàng)建非聚集索引IDX_cname。USE t

18、eachingGOCREATE NONCLUSTERED INDEX IDX_cname ON course(cname)GO02 程序代碼如下：USE teachingGOIF EXISTS(SELECT name FROM sysindexes WHERE name='UQ_stu') DROP INDEX GOCREATE NONCLUSTERED INDEX UQ_stu ON student(studentno,classno)GOSELECT * FROM student03 程序代碼如下：USE teachingGOALTER INDEX UQ_stu ON st

19、udent REBUILD WITH (PAD_INDEX = ON, FILLFACTOR = 80)GO04 程序代碼如下：-創(chuàng)建一個視圖v_teacher，查詢所有“計算機學(xué)院”教師的信息。USE teachingGOCREATE VIEW v_teacherASSELECT *FROM teacherWHERE department = '計算機學(xué)院'GOSELECT * FROM v_teacher05 程序代碼如下：-創(chuàng)建一個視圖v_avgstu，查詢每個學(xué)生的學(xué)號、姓名及平均分，并且按照平均分降序排序。USE teachingGOCREATE VIEW v_avg

20、stuASSELECT TOP(100) PERCENT , , AVG AS 'average'FROM student, scoreWHERE = AND IS NOT NULLGROUP BY , ORDER BY AVG DESCGOSELECT * FROM v_avgstu06 程序代碼如下：-修改v_teacher的視圖定義，添加WITH CHECK OPTION選項。USE teachingGO ALTER VIEW v_teacherASSELECT *FROM teacherWHERE department = '計算機學(xué)院'WITH CHE

21、CK OPTIONGO07 程序代碼如下：-通過視圖v_teacher向基本表teacher中分別插入數(shù)據(jù)('05039', '張馨月', '計算機應(yīng)用', '講師', '計算機學(xué)院')和('06018', '李誠', '機械制造', '副教授', '機械學(xué)院')，并查看插入數(shù)據(jù)情況。USE teachingGO INSERT INTO v_teacher VALUES('05039','張馨月',

22、9;計算機應(yīng)用','講師','計算機學(xué)院')INSERT INTO v_teacher VALUES('06018','李誠','機械制造','副教授','機械學(xué)院')GOSELECT * FROM v_teacherSELECT * FROM teacher08 程序代碼如下：-通過視圖v_teacher將基本表teacher中教師編號為'05039'的教師職稱修改為'副教授'。USE teachingGO UPDATE v_teacherS

23、ET prof = '副教授'WHERE teacherno = '05039'GOSELECT * FROM teacher第八章3 上機練習(xí)題01 程序代碼如下：-創(chuàng)建一個名稱為StuInfo的存儲過程，要求完成以下功能：-在student表中查詢級學(xué)生的學(xué)號、姓名、性別、出生日期和電話個字段的內(nèi)容USE teaching-查詢是否已存在此存儲過程，如果存在，就刪除它IF EXISTS (SELECT name FROM sysobjects WHERE name = 'StuInfo' AND type = 'P') DRO

24、P PROCEDURE StuInfoGO-創(chuàng)建存儲過程CREATE PROCEDURE StuInfo ASSelect studentno,sname,sex,birthday,phone FROM studentWHERE substring(studentno,1,2)='08'GO02 程序代碼如下：-創(chuàng)建一個存儲過程ScoreInfo，-完成的功能是在表student、表course和表score中查詢以下字段：學(xué)號、姓名、性別、課程名稱、期末分數(shù)。USE teaching-查詢是否已存在此存儲過程，如果存在，就刪除它IF EXISTS (SELECT name F

25、ROM sysobjects WHERE name = 'ScoreInfo' AND type = 'P') DROP PROCEDURE ScoreInfoGO-創(chuàng)建存儲過程CREATE PROCEDURE ScoreInfo ASSelect , FROM student,course,scoreWHERE = and =GO03 程序代碼如下：-創(chuàng)建一個帶有參數(shù)的存儲過程Stu_Age，-該存儲過程根據(jù)輸入的學(xué)號，在student表中計算此學(xué)生的年齡，-并根據(jù)程序的執(zhí)行結(jié)果返回不同的值，程序執(zhí)行成功，返回整數(shù)，如果執(zhí)行出錯，則返回錯誤號。-刪除已存在的存

26、儲過程USE teachingIF EXISTS (SELECT name FROM sysobjects WHERE name = 'Stu_Age' AND type = 'P') DROP PROCEDURE Stu_AgeGO-創(chuàng)建存儲過程USE teachingGOCREATE PROCEDURE Stu_Age studentNO nvarchar(10),Age int OUTPUTAS -定義并初始化局部變量，用于保存返回值DECLARE ErrorValue intSET ErrorValue=0-求此學(xué)生的年齡SELECT Age=YEAR(

27、GETDATE()-YEAR(birthday) FROM studentWHERE studentno=studentNO-根據(jù)程序的執(zhí)行結(jié)果返回不同的值IF (ERROR<>0) SET ErrorValue=ERRORRETURN ErrorValueGO04 程序代碼如下：- =- Template generated from Template Explorer using:- Create Trigger (New Menu).SQL- Use the Specify Values for Template Parameters - command (Ctrl-Shif

28、t-M) to fill in the parameter - values below.- See additional Create Trigger templates for more- examples of different Trigger statements.- This block of comments will not be included in- the definition of the function.- =SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO- =- Author:Name- Create date: -

29、Description:- =CREATE TRIGGER ON AFTER INSERTAS BEGINDECLARE msg nchar(30) SET msg='你插入了一條新記錄！' PRINT msgENDGO05 程序代碼如下：-創(chuàng)建一個AFTER觸發(fā)器，要求實現(xiàn)以下功能：-在score表上創(chuàng)建一個插入、更新類型的觸發(fā)器TR_ScoreCheck，-當(dāng)在score字段中插入或修改考試分數(shù)后，觸發(fā)該觸發(fā)器，檢查分數(shù)是否在-100之間。USE teachingGOCREATE TRIGGER TR_ScoreCheckON scoreFOR INSERT, UPDATE

30、 ASIF UPDATE(final )PRINT 'AFTER觸發(fā)器開始執(zhí)行'BEGIN DECLARE ScoreValue real SELECT ScoreValue=(SELECT final FROM inserted) IF ScoreValue>100 OR ScoreValue<0 PRINT '輸入的分數(shù)有誤，請確認輸入的考試分數(shù)！'ENDGO06 程序代碼如下：-創(chuàng)建一個INSTEAD OF觸發(fā)器，要求實現(xiàn)以下功能：-在course表上創(chuàng)建一個刪除類型的觸發(fā)器TR_NotAllowDelete，-當(dāng)在course表中刪除記錄時，

31、觸發(fā)該觸發(fā)器，顯示不允許刪除表中數(shù)據(jù)的提示信息。USE teachingGOIF EXISTS(SELECT name FROM sysobjects WHERE name ='TR_NotAllowDelete' AND type = 'TR') DROP TRIGGER TR_NotAllowDeleteGOCREATE TRIGGER TR_NotAllowDeleteON courseINSTEAD OF DELETEAS PRINT 'INSTEAD OF 觸發(fā)器開始執(zhí)行' PRINT '本表中的數(shù)據(jù)不允許被刪除！不能執(zhí)行刪除操

32、作!'GO第九章3 上機練習(xí)題01 程序代碼如下：-創(chuàng)建在score表上執(zhí)行UPDATE語句的事務(wù)UP_score，并執(zhí)行。USE teachingGOBEGIN TRAN UPDATE SET usually=77,final=88 WHERE studentno='07' AND courseno='c05109' COMMIT TRANGO02 程序代碼如下：-練習(xí)使用ROLLBACK TRANSACTION語句回滾事務(wù)，并查看。USE teachingGOBEGIN TRAN INSERT INTO course VALUES('c051

33、33','國際貿(mào)易','必修',32,; SAVE TRAN save1; DELETE FROM course WHERE courseno='c05137' ROLLBACK TRAN save1;COMMIT TRANGO03 程序代碼如下：-練習(xí)在student表上創(chuàng)建嵌套事務(wù)，分別在內(nèi)層和外層設(shè)置回滾點，檢測回滾對表數(shù)據(jù)的影響。USE teachingGOBEGIN TRAN tran1 SAVE TRAN save1; BEGIN TRAN tran2 UPDATE student SET sname='趙平茵'

34、;,point=997,phone='0727' WHERE studentno='07' SELECT * FROM student WHERE studentno='07' SAVE TRAN save2; COMMIT TRAN tran2 ; UPDATE student SET sname='孫釋遠',point=987,phone='0727' WHERE studentno='07' ROLLBACK TRAN save1;COMMIT TRAN tran2;SELECT * FROM

35、 student WHERE studentno='07'GO04 程序代碼如下：-練習(xí)在student表上創(chuàng)建嵌套事務(wù)，并利用系統(tǒng)變量TRANCOUNT編程，-檢測嵌套事務(wù)的執(zhí)行情況。USE teachingGOBEGIN TRAN TR1 PRINT '1st BEGIN TRAN: TRANCOUNT=' + CAST(TRANCOUNT AS NVARCHAR(10); SAVE TRAN save1; BEGIN TRAN TR2 PRINT '2nd BEGIN TRAN: TRANCOUNT=' + CAST(TRANCOUNT A

36、S NVARCHAR(10); UPDATE student SET sname='趙平茵',point=997,phone='0727' WHERE studentno='07' COMMIT TRAN TR2; PRINT '1st COMMIT TRAN: TRANCOUNT=' + CAST(TRANCOUNT AS NVARCHAR(10); -ROLLBACK TRAN save1; PRINT 'ROLLBACK TRAN: TRANCOUNT=' + CAST(TRANCOUNT AS NVARCH

37、AR(10);COMMIT TRAN TR1;PRINT 'AFTER COMMIT TRAN TR1: TRANCOUNT=' + CAST(TRANCOUNT AS NVARCHAR(10); SELECT * FROM student WHERE studentno='07'GO05 程序代碼如下：-練習(xí)在student表上進行查詢、插入和更新，然后使用視圖查看鎖的信息。USE teaching;GOBEGIN TRAN SELECT studentno,sname FROM student-WITH(holdlock, rowlock) WHERE st

38、udentno='07' INSERT INTO student VALUES('01','孫釋遠','女','1989-09-09','090512',777,'76',''); UPDATE student SET sname='孫釋嘉' WHERE studentno='07'-為了查看事務(wù)中使用的鎖的信息，使用動態(tài)管理視圖。在查詢窗口中鍵入并執(zhí)行以下SELECT語句來獲取鎖信息并提交事務(wù)。SELECT resource_type

39、, resource_associated_entity_id, request_status, request_mode, request_session_id, resource_descriptionFROM WHERE resource_database_id=DB_ID('teaching');-提交事務(wù)COMMIT TRAN第十章3 上機練習(xí)題01 程序代碼如下：USE masterGOCREATE LOGIN USER1 WITH PASSWORD =' Abc!#213'03 程序代碼如下：-練習(xí)在teaching數(shù)據(jù)庫中為SQL Server登

40、錄名USER1添加數(shù)據(jù)庫用戶，并取名為USER2，默認架構(gòu)為TEAC。USE teachingGOCREATE USER USER2 FOR LOGIN USER1WITH DEFAULT_SCHEMA =TEACGO 05 程序代碼如下：-練習(xí)將teaching數(shù)據(jù)庫中創(chuàng)建表的權(quán)限授予用戶USER2。USE teachingGOGRANT CREATE TABLE TO USER2GO第十一章3 上機練習(xí)題01 程序代碼如下：-完整數(shù)據(jù)庫備份USE teaching GOBACKUP DATABASE teaching TO DISK = N'F:sqlprogram_ex第章bac

41、kteaching' WITH EXPIREDATE = N'12/22/2009 00:00:00', NAME = N'teaching-完整數(shù)據(jù)庫備份',STATS = 10GO-差異備份BACKUP DATABASE teaching TO DISK = N'F:sqlprogram_ex第章backteaching' WITH DIFFERENTIAL , EXPIREDATE = N'12/22/2009 00:00:00', NOFORMAT, NOINIT, NAME = N'teaching-差異

42、數(shù)據(jù)庫備份', SKIP, NOREWIND, NOUNLOAD, STATS = 10GOdeclare backupSetId as intselect backupSetId = position from msdb.backupset where database_name=N'teaching' and backup_set_id=(select max(backup_set_id) from msdb.backupset where database_name=N'teaching' ) if backupSetId is null begi

43、n raiserror(N'驗證失敗。找不到數(shù)據(jù)庫“teaching”的備份信息。', 16, 1) endRESTORE VERIFYONLY FROM DISK = N'F:sqlprogram_ex第章backteaching' WITH FILE = backupSetId, NOUNLOAD, NOREWINDGO02 程序代碼如下：-對數(shù)據(jù)庫teaching進行恢復(fù)RESTORE DATABASE teaching FROM DISK = N'F:sqlprogram_ex第章backteaching' WITH FILE = 2,

44、NORECOVERY, NOUNLOAD, STATS = 10GORESTORE DATABASE teaching FROM DISK = N'F:sqlprogram_ex第章backteaching' WITH FILE = 3, NOUNLOAD, STATS = 10GO03 程序代碼如下：-創(chuàng)建備份設(shè)備USE masterGOEXEC devtype = N'disk', logicalname = N'device1', physicalname = N'F:sqlprogram_ex第章'GO-備份teachin

45、g數(shù)據(jù)庫的事務(wù)日志BACKUP LOG teaching TO device1 WITH RETAINDAYS = 3, NOFORMAT, NOINIT, NAME = N'teaching-事務(wù)日志備份', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO第十二章3 上機練習(xí)題02 程序代碼如下：USE msdbGODECLARE jobId BINARY(16)EXEC job_name=N'student', category_name=N'Uncategorized (Local)', owner_login

46、_name=N'JIANG-N9VJWXJ11Administrator', job_id = jobId OUTPUTGOEXEC job_name=N'student', server_name = N'JIANG-N9VJWXJ11'GODECLARE schedule_id intEXEC job_name=N'student', name=N'plan1', active_start_date=, active_end_date=, active_start_time=100000, active_end

47、_time=235959, schedule_id = schedule_id OUTPUTGO03 程序代碼如下：USE msdbGOEXEC name=N'alert1', message_id=0, severity=8, enabled=1, delay_between_responses=30, include_event_description_in=1, notification_message=N'交易時間即將結(jié)束，請及時處理數(shù)據(jù)', job_id=N'db8abb83-8552-49b0-a613-0c223a0bbfdd'GO

48、EXEC alert_name=N'alert1', operator_name=N'jiang', notification_method = 1GO04程序代碼如下：USE msdbGOEXEC name=N'operator', enabled=1, weekday_pager_start_time=80000, weekday_pager_end_time=180000, pager_days=62, email_address=N''GOEXEC alert_name=N'alert1', operato

49、r_name=N'operator', notification_method = 1GOEXEC alert_name=N'testAlert1', operator_name=N'operator', notification_method = 1GO05 程序代碼如下：USE msdbGO-創(chuàng)建事務(wù)BEGIN TRANSACTIONDECLARE ReturnCode INTSELECT ReturnCode = 0-創(chuàng)建維護計劃maintain1DECLARE jobId BINARY(16)EXEC ReturnCode = job_n

50、ame=N'maintain1', enabled=1, notify_level_eventlog=2, notify_level_email=2, notify_level_netsend=0, notify_level_page=0, delete_level=0, description=N'無描述。', category_name=N'Database Maintenance', owner_login_name=N'JIANG-N9VJWXJ11Administrator', notify_email_operator

51、_name=N'jiang', job_id = jobId OUTPUTIF (ERROR <> 0 OR ReturnCode <> 0) GOTO QuitWithRollback-創(chuàng)建子計劃day_planEXEC ReturnCode = job_id=jobId, step_name=N'子計劃', step_id=1, cmdexec_success_code=0, on_success_action=1, on_success_step_id=0, on_fail_action=2, on_fail_step_id=0,

52、retry_attempts=0, retry_interval=0, os_run_priority=0, subsystem=N'SSIS', command=N'/Server JIANG-N9VJWXJ11 /SQL "Maintenance Plansmaintain1" /set "Package子計劃.Disable;false"', flags=0IF (ERROR <> 0 OR ReturnCode <> 0) GOTO QuitWithRollbackEXEC ReturnCo

53、de = job_id = jobId, start_step_id = 1IF (ERROR <> 0 OR ReturnCode <> 0) GOTO QuitWithRollbackEXEC ReturnCode = job_id=jobId, name=N'day_plan', enabled=1, freq_type=4, freq_interval=1, freq_subday_type=1, freq_subday_interval=0, freq_relative_interval=0, freq_recurrence_factor=0,

54、 active_start_date=, active_end_date=, active_start_time=0, active_end_time=235959IF (ERROR <> 0 OR ReturnCode <> 0) GOTO QuitWithRollbackEXEC ReturnCode = job_id = jobId, server_name = N'(local)'IF (ERROR <> 0 OR ReturnCode <> 0) GOTO QuitWithRollbackCOMMIT TRANSACTIONGOTO EndSaveQuitWithRollback:IF (TRANCOUNT > 0) ROLLBACK TRANSACTIONEndSave:第十三章3 上機練習(xí)題01 程序代碼如下：-練習(xí)對teaching數(shù)