數(shù)據(jù)庫課程設(shè)計(jì)sqlserver圖書館管理系統(tǒng)實(shí)例講解-wenkub
2023-04-22 23:10:29 本頁面
【正文】 ect total=count(*,i=1from Studentwhile(i=totalbegin查詢數(shù)據(jù)表第i 行數(shù)據(jù)地SQL語句selecttop 1 sno=Sno from Student where Sno notin(selecttop(i1 Sno from Studentasfpsfpi4kupdate Studentset SMajorNo=substring(sno,4,4where Sno=snoset i=i+1endgo結(jié)果如下： 查詢每個(gè)學(xué)生對書本地借閱數(shù)量查詢每個(gè)學(xué)生對書本地借閱數(shù)量use LibrarySystemgoselect 學(xué)號,Sname 姓名, 圖書分類號,Bname 書名ooeyYZTjj1from StudentBook,Student,Bookwhere = and =orderby putecount(by go結(jié)果如下:use LibrarySystemgodeclare tempDept table(專業(yè)編號char(4primarykey,專業(yè)varchar(30notnull,學(xué)生借閱書本數(shù)量intdefault 0Insertinto tempDept(專業(yè)編號,專業(yè)select Mno,Mname from MajorPgdO0sRlModeclare i int,total int,no char(10select total=count(*,i=1 from StudentBookwhile(itotalbeginselecttop 1 no=Sno from StudentBook where Sno notin(selecttop(i1 Sno from StudentBook3cdXwckm15update tempDeptset 學(xué)生借閱書本數(shù)量=學(xué)生借閱書本數(shù)量+1where 專業(yè)編號=substring(no,4,4set i=i+1endselect*from tempDeptselect total as 學(xué)生借閱書本總量go結(jié)果如下:后續(xù)“數(shù)據(jù)庫課程設(shè)計(jì)之《SQL Server圖書館管理系統(tǒng)》源碼”五、圖書館管理系統(tǒng)數(shù)據(jù)庫、數(shù)據(jù)表源代碼六、圖書館管理系統(tǒng)存儲過程源代碼七、圖書館管理系統(tǒng)觸發(fā)器源代碼：763157698。讀者查詢圖書借閱情況實(shí)例use
公司管理相關(guān)推薦
鄂ICP備17016276號-1