【正文】 5and e=85and f=85and g=85print39。 else if a=80 and b=80 and c=80 and d=80 and e=80 and f=80 andg=80 print39。 else if a=70 and b=70 and c=70 and d=70 and e=70 and f=70 and g=70 and (a+b+c+d+e+f+g)/7=75 print39。 else print39。 在創(chuàng)建好存儲過程后，判斷某同學是否獲獎學金 exec jxjpb 39。 三、改進在獎學金評定過程中，考慮綜合測評的因素。（一）綜合測評能獲得獎學金的同學:創(chuàng)建視圖：綜合測評能獲得一等獎學金的同學create view BalanceMeasuresFirst as select top 17 percent * from BalanceMeasures 創(chuàng)建視圖：綜合測評能獲得二等獎學金的同學create view BalanceMeasuresSecondasselect top 30 percent * from BalanceMeasures創(chuàng)建視圖：綜合測評能獲得三等獎學金的同學create view BalanceMeasuresThird as select top 60 percent * from BalanceMeasures (2) 憑各項成績能獲得獎學金的同學： 創(chuàng)建視圖：各項成績獲一等獎學金create view as select as39。, StudentName as 39。 from ScoreInfo,StudentInfo where =group by ,StudentNamehaving min(Score)=85 go 創(chuàng)建視圖：各項成績獲二等獎學金（不包括各項成績獲得一等的同學）create viewas select as39。, StudentName as 39。 from ScoreInfo,StudentInfo where = group by ,StudentName having min(Score)=80 and min(Score)85 theSecondClassScholarship go 創(chuàng)建視圖：各項成績獲三等獎學金（不包括各項成績獲得一等和二等的同學）create view as select as39。, StudentName as 39。 from ScoreInfo,StudentInfo where = group by ,StudentNamehaving min(Score)=70 and min(Score)80 and avg(Score)=75 go （3） 評定最終獲得獎學金的同學：最終獲得一等獎學金的同學 Create view ScholarshipFirst as select distinct ,from BalanceMeasuresFirst,theFirstClassScholarshipwhere =theFirstClassScholarship .學號go 最終獲得二等獎學金的同學Create view ScholarshipSecond as select distinct ,from BalanceMeasuresSecond,theSecondClassScholarshipwhere BalanceMeasuresSecond .學號=theSecondClassScholarship .學號And not in(select 號from theFirstClassScholarship) go 最終獲得三等獎學金的同學 create view ScholarshipThird as select distinct ,from BalanceMeasuresThird,theThirdClassScholarshipwhere BalanceMeasuresThird .學號=theThirdClassScholarship .學號 and in (select theFirstClassScholarship. 學號 from theFirstClassScholarship) and BalanceMeasuresThird學號not in (select theSecondClassScholarship. 學號 from theSecondClassScholarship) and not exists(select * from abc where 學號=) and in (select 學號from abc) go (4) 驗證獎學金獲得情況：create procedure ScholarshipCheck a char(10) as if exists(select * from theFirstClassScholarship where 學號=a ) print39。 else if exists (select * from theSecondClassScholarship where 學號=a ) print39。 else if exists(select * from theThirdClassScholarship where 學號=a ) print39。 else print39。 （5） SQL 查詢語句導出數(shù)據(jù)庫新建查詢，輸入語句： EXEC master..xp_cmdshell 39。 庫名 表名 存儲路徑 登錄 用戶名 密碼 EXEC sp_configure 39。, 1。EXEC sp_configure 39。, 1。出現(xiàn)錯誤： 消息15281，級別16，狀態(tài)1，過程xp_cmdshell，第1 行 SQL Server阻止了對組件阻止了對組件39。的過程的過程39。 的訪問，因 的訪問，為此組件已作為此服務器安全配置的一部分而被關閉。有關啟用39。 的詳細信息，請參閱 SQL Server 聯(lián)機叢書中的外圍應用配置器 。配置選項39。 已從0 更改為 1。配置選項39。已從更改為。請運行RECONFIGURE 語句進行安裝。show advanced options39。RECONFIGURE。xp_cmdshell39。RECONFIGURE ”；或?qū)㈠e誤輸入百度中收索，將錯誤輸入百度中收索，打開‘恢復xp 阻止了一句話解決‘ 打開‘恢復 cmdshel S