sql數(shù)據(jù)庫期末復習備考必備-免費閱讀
【正文】 什么是奮斗？奮斗就是每天很難，可一年一年卻越來越容易。create table stu_credit (sno char(10) primary key, credit char(20), )create trigger stuTiron skcfor delete asupdate stu_credit set kcredit= kcredit(select kcredit from stu_credit where sno=)創(chuàng)建一個觸發(fā)器，當在skc中添加一個學生選課的時候，驗證學生所選的總學分，如果已選學分超過10分，則拒絕學生本次選修。create proc cStuNostuNumber char(10)asselect avg(grade) 39。劉永強39。并描述每一部分的功能或者輸出結果。請分析數(shù)據(jù)庫各個表及字段的使用情況，然后為經(jīng)常查詢和分組的字段創(chuàng)建索引。吳明39。 create view view_avg_all(sno,sname,mname)asselect sno,mnamefrom student s,major mwhere =39。,39。張%39。金融系39。金融系39。,39。數(shù)據(jù)庫的備份：Backup database stuManageTO disk=39。查詢出每門課程的平均分、最低分、最高分Select kno,max(grade),min(grade),avg(grade)From skcgroup by kno查詢出平均分大于80分，且至少選修了2門課程的學生學號。skc_grade_index39。10000339。where sno=39。create clustered index mycolumn_index on mytable為一些表中不允許重復的字段創(chuàng)建唯一性索引。1）創(chuàng)建觸發(fā)器CREATE TABLE TestTable1 ( 創(chuàng)建表TestTable1)c1 INT,c2 CHAR(30))CREATE TRIGGER trig1 ON TestTable1 FOR INSERT,UPDATE,DELETEas SELECT * FROM TestTable1下面兩個語句分開執(zhí)行INSERT TestTable1 VALUES(1,’林沖’)UPDATE TestTable1 SET c2=‘宋江’ WHERE c1=12）inserted表和deleted表的使用CREATE TRIGGER trig1ON TestTable1FOR INSERT,UPDATE,DELETEASPRINT ‘inserted表：’SELECT * FROM INSERTEDPRINT ‘deleted表：’SELECT * FROM DELETEDGO下面三個語句分開執(zhí)行INSERT TestTable1 VALUES(2,’吳用’)UPDATE TestTable1 SET c2=‘關勝’ WHERE c1=2DELETE TestTable1 WHERE c1=23）insert和update觸發(fā)器CREATE TABLE TestTable2( c1 INT, c2 CHAR(10))GOCREATE TRIGGER trig2 ON TestTable2 FOR INSERT,UPDATEASDECLARE c1_1 intSELECT c1_1=c1 FROM INSERTEDIF c1_11 OR c1_1108BEGIN ROLLBACK RAISERROR(‘c1值必須在1到108之間！’,16,1)ENDGO下面三個語句分開執(zhí)行INSERT TestTable2 VALUES (200,’武松’)INSERT TestTable2 VALUES (15,’武松’)UPDATE TestTable2 SET c1=300 WHERE c2=‘武松’4）delete觸發(fā)器INSERT stu VALUES (‘03170356’,’陳功’,’男’,17,’廣東’)INSERT study VALUES (‘03170356’,1,88)INSERT study VALUES (‘03170356’,2,99)GO
教學教案相關推薦
鄂ICP備17016276號-1