SQL实验报告实验三

《SQL实验报告实验三》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、1•打开数据库SQLServer2000的查询分析器，用CreateTable建表SCI。SQLQueryl.sql・(L..dministrator(54))*

2、▼XEcreatetablesol(snochar(5)renochar(5)9Lgradeint);◎一—m區结果命令已成功完成。4►©1(local)(10.0RTM)PC-20130924ACEKAdmini...00:00:000行SQLQuery2sql-((.administrator(56))*altertablestudentaltercolumnsag

3、eintnr肉消息命令已成功完成:SQLQuery2.sql・(l^dministrator(56))*select*fromstudent;insnosnamessexsagesdeptscome1I200215121i李勇禺20csNULL2200215122刘晨女19csNULL3200215123王敏女18maNULL4200215124张立男19isNULLJ结果消息SQLQuery2sql-^.administrator(56))*altertablestudentaltercolumnsageintnr矗消息命令已成功

4、尧成;SQLQuery2sql・0^dministrator(56))*createuniqueindexindexss

5、onstudent(snair.easc);<

6、rrr鬲7肖息命令已成功完成0lzlcrhmadltka^c.cruoaccAac匚sa丿…："：云z二处nn.nn.nncQ..SQLQuery2>sql-^administrator(56))*dropindexindexsonstudent;

7、

8、秦延龙I00:00:00I0行（二）DML的数据查询SQLQuery2.sql・(l...dministrator(56))*select*fromstudent;

9、结果消息TXsnosnamessexsagesdeptscome1I200215121i李勇男20csNULL2200215122刘晨女19csNULL3200215123王敏女18maNULL4200215124张立男19isNULLSQLQuery2.sql・(l.^.dministrator(56))*selectdistinctsnofromsc;结果消息sno

10、2002151212200215122SQLQuery2.sql・(l...dministrator(56))*日selectdistinctsnofrorr.scLwheregrade<90

11、;TXSQLQuery2.sql-^administrator(56))衰□selectsnorsnamefromstudentLwhereadeptin(1ma1r1is1r1csl1);rrrsnosname1：200215121I李勇2200215122刘晨3200215123王敏4200215124张立SQLQuery2.sql-(l

12、^dministrator(56))齐！□selectsno,snair.e,ssexfromstudentLwheresnair.elike1l]%1;

13、启结果匕消息snosnamessex1200215122刘晨女SQLQuery2.sql・(l...dministrator(56))*E]selectcpnorccreditfromcoursewherecnamelike1db_design1一escape11;

14、r—nr结果丄」消息cpnoccreditSQLQuery2.sql-(l...dministrator(56

15、))*

16、"X日selectsnoz

17、gradefromsc一wherecno=131Lorderbygradedesc;°IJE□结果A肖息snograde120021512188220021512280SQLQuery2.sql-(l^dministrator(56))*□select卜1AX(grad亡)，最高分■fromscI-wherecno=f11;塾结果區消息最高分J_92j©

18、(local)(10.0RTM)

19、PC:20130924ACEKAdmini...

20、秦包

21、00:00:001行/SQLQuery2sql・0^

22、dministrator(56))*T:Bselecteno,COUNT(sno)fromsc-Lgroupbyeno;rn□结果由消息enoGE列名）1I1I1222332/SQLQuery2sql-0Mdministrator(5