sqlserver课后习题答案（SQLServer课后习题答案）

《sqlserver课后习题答案（SQLServer课后习题答案）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

sqlserver⚪ᫀSQLServer⚪ᫀ
₝ᦪtestlᙠឋname=testldatal,ᦻ=\testldatal!"#”%Imbᜧ)*10mbMAXSIZE=,34561MB8,name=testldata2,ᦻ=\testldata2NDF",Imbᜧ)=,10mbMAXSIZE=,34561MB8>?(name=testllogl,

1ᦻ=\testlloglLDF",512kbᜧ)=,5mbMAXSIZE=,3456512KB)HᦋᦪtestlJᦋᦻ(name=testldatal,2mbᜧ)=)HᦋᦪtestlJᦋᦻ(name=testldatal,20mbMAXSIZE=)HᦋᦪtestlJᦋᦻ

2(name=testldatal,34562mb)HᦋᦪtestlJᦋᦻ(name=testldata2,2mbᜧ)=)HᦋᦪtestlJᦋᦻ(name=testldata2,20mbᜧ)=)HᦋᦪtestlJᦋᦻ

3(name=testldata2,2mbᜧ)=)KLM⊤OP⊤(OQchar(8)V6W,Xchar(6),ឋZchar(2),[P\]DateTime,`achar(20))⊤ᡂc⊤(OQchar(8)V6W,defQchar(3)V6W,

4ᡂcᓝiᑴ4,188⊤de⊤defQchar38V6W%dechar208,Oᑖint8Jᦋ⊤OP⊤mnopqrXHOQ8Jᦋ⊤ᡂc⊤mnopqrxhkcOQ%defQ8Jᦋ⊤de⊤mnopqrkcbhdefQ8Jᦋ⊤ᡂc⊤

5mn᜜pqrxhwjOQ8xὃOP⊤OQ8Jᦋ⊤ᡂc⊤mn᜜pqrkcbhwjdefQ8xὃde⊤defQ8Jᦋ⊤ᡂc⊤mnqrḄCJ}ἠᡂc01008Jᦋ⊤OP⊤mnqrZY"”`aKM⌱X%[P\]%`aOP⊤ᙠឋZ="ᵱ”⌱*de⊤ᙠde“⌱⚞Ḅ3ᡂc⊤

6ᙠdefQ=“001”ᡂc᎔⌱X%de%ᡂcOP⊤ᙠOP⊤nᐭᡂc⊤஺OQ=ᡂc⊤஺OQᙠᡂc⊤nᐭde⊤஺defQ=de⊤஺defQᙠᡂc⊤஺defQ=0018090Ḅᡂc⌱*OP⊤ᙠ`a“‘%‘ᵯ£ᖪ¥‘%’§¨©ᢈ«”8⌱de%⌱AVGᡂc8ᡂc⊤ᙠᡂc⊤nᐭde⊤஺defQ=de⊤஺defQᙠde="®ᵨ°Ạ”8²6³ᙳᡂcde⊤ᙠde="®ᵨ°Ạ”⌱defQ%ᦪ*86Jd*ᦪ

7ᡂc⊤µ¶defQ⌱*ᡂc⊤ᙠdefQ='001”³ᙳᡂc8%ᨬᜧᡂc8%minᡂc8⌱X%de%ᡂcOP⊤ᙠOP⊤nᐭᡂc⊤஺OQ=ᡂc⊤஺OQᙠde⊤nᐭde⊤஺defQ=ᡂc⊤஺defQᙠឋZ="᝕de="®ᵨᢈ«”⌱OP⊤஺OQ%X%de%ᡂcOP⊤ᙠOP⊤nᐭᡂc⊤஺OQ=ᡂc⊤஺OQᙠde⊤nᐭde⊤஺defQ=ᡂc⊤஺defQᙠᡂc⊤஺defQ='001ᡂcº⌱AVGᡂc8ᡂc⊤»defQ='001”8

8SELECT*FROMᡂc⊤²6ᙠᡂcº⌱AVGᡂc8ᡂc⊤6B,A=BdefQdefQ8SELECT*FROMde⊤ᙠdefQ¾ᨵ⌱defQᡂc⊤8Àᐭᡂc⊤Á'20030101'005'ஹ'80Ã'8HÄde⊤µOᑖ=Oᑖ+1defQ='001”ᑤ◀ᡂc⊤OP⊤%ᡂc⊤ᙠOP⊤஺OQ=ᡂc⊤஺OQᡂc⊤OQ='20030101”஺ᑤ◀OP⊤»OQ=520030101"KÈMKÈMdÃÉÊ1ஹËÌOPᡂc²6⌱AOQ%X%de%ᡂc%`aOP⊤²6nᐭᡂc⊤BÍA=BOQOQ

9nᐭde⊤CᙠBdefQ=CdefQ2ஹspaddtype'Ð'%'varchar188"ஹ"VW"sphelpCNOsp_droptypeCNOLஹÓ²6getdateOsp_bindefault”Ó‘%‘OP⊤[P\]”஺SELECT*FROMOP⊤Jᦋ⊤OP⊤1mnᐭOÓCNO,ÖaÓ1CNOÀᐭOP⊤OQ%X%ឋZ%`a%ᐭOÓ1,ÖaÓ18Á'20097501ØL‘%‘᝕%2009Ù%2012Ù”8SELECT*FROMOP⊤spbindefaultvÓ'%'eno'futureonly”

10sp_bindefault"Ó'%'enol"sp_helpenolSELECT*FROMOP⊤Jᦋ⊤OP⊤JᦋᑡḄᐭOÓ1CNOJᦋ⊤OP⊤JᦋᑡḄÖaÓ1enolSELECT*FROMOP⊤ÀᐭOP⊤OQ%X%ឋZ,`a8Á'20097504ÛÈ'%'᝕''”8SELECT*FROMOP⊤ÜᑣḄÞ²6@Áàá“”Jᦋ⊤OP⊤

11mnᵯ£Þvarchar208sp_bindrule'ᵯ£Þ‘%‘OP⊤ᵯ£Þ”஺âJᦋ⊤ᡂc⊤mnãᔲ⊡ὃchar48SELECT*FROMᡂc⊤æᘤ⊡ὃᙠᡂc⊤HÄò6᝞é⌱ᡂc⊤஺ᡂcᡂc⊤%Àᐭᡂc⊤஺OQ=Àᐭ஺OQᡂc⊤஺defQ=Àᐭ஺defQ8º60HÄᡂc⊤µãᔲ⊡ὃ="ᔲ”ᙠOQ⌱OQÀᐭ8defQᙠ⌱defQÀᐭ8ᐸëḄHÄᡂc⊤µãᔲ⊡ὃ="ã”ᙠOQ⌱OQÀᐭ8defQᙠ⌱defQÀᐭ8

12ᡈὅ5Jᦋ⊤ᡂc⊤mnãᔲ⊡ὃchar48SELECT*FROMᡂc⊤æᘤ⊡ὃᙠᡂc⊤Àᐭò6᝞é⌱ᡂc⊤஺ᡂcᡂc⊤%Àᐭᡂc⊤஺OQ=Àᐭ஺OQᡂc⊤஺defQ=Àᐭ஺defQ8º60HÄᡂc⊤µãᔲ⊡ὃ="ᔲ”ᙠOQ⌱OQÀᐭ8defQᙠ⌱defQÀᐭ8ᐸëḄHÄᡂc⊤µãᔲ⊡ὃ="ã”ᙠOQ⌱OQÀᐭ8defQᙠ⌱defQÀᐭ8KîMïðOP³ᙳᑖ⌼òó

13(@Xvarchar(10)=“ØL'%”OQvarchar(20)="20030101”)ôõᦈ÷øùúû@ïðOP³ᙳᑖô⌱“ïðOP³ᙳᑖ=AVG(ᡂc)OP⊤ᙠOP⊤nᐭᡂc⊤஺OQ=ᡂc⊤஺OQᙠX=@Xᡂc⊤஺OQ=@OQüý“ïðOP³ᙳᑖþr⌱dbo஺ïðOP³ᙳᑖ(‘ÿ‘‘20030101J)ᙳᑖḄᑖ⌼(@varchar(10)=“$%'”(varchar(20)="20030101”)*+int/012@Ḅᑖint

14⌱4“Ḅᑖ=56ᑖ78⊤ᙠ⊤;ᐭᡂ>⊤஺(=ᡂ>⊤஺(ᙠ@A⊤;ᐭ@A⊤஺@AB(=ᡂ>⊤஺@AB(ᙠ=@5ᡂ>⊤஺(=஺(*+“ḄᑖCD⌱4dbo஺Ḅᑖ6‘H‘‘20030101J7ᑖIᔜKᡂ>6@(varchar62077ᦈM⊤*+6⌱4⊤஺(@AB(ᡂ>8⊤ᙠ⊤;ᐭᡂ>⊤஺(=ᡂ>⊤஺(ᙠ=@(7SELECT*FROMᔜKᡂ>6‘H”7

15IᔜKᡂ>(@(varchar(20))*+“⊤⊤((char(10),varchar(20),@AB(char(10),@Avarchar(20),ᡂ>char(10))/0᝞Z“([\Ḅ]ᐭ“⊤⌱4⊤஺(⊤஺ᡂ>⊤஺@AB(@Aᡂ>8⊤ᙠ⊤;ᐭᡂ>⊤஺(=ᡂ>⊤஺(;ᐭ@A⊤ᙠᡂ>⊤஺@AB(=@A⊤஺@AB(ᐸ_Ḅ]ᐭ“⊤⌱4⊤஺(⊤஺ᡂ>⊤஺@AB(@Aᡂ>8⊤ᙠ⊤;ᐭᡂ>⊤஺(=ᡂ>⊤஺(;ᐭ@A⊤ᙠᡂ>⊤஺@AB(=@A⊤஺@AB(

16ᙠ⊤஺(=@(*+CDSELECT*FROMᔜKᡂ>6'20030101"7ᡈSELECT*FROMᔜKᡂ>6ab7IcA@A1“@Advarchar6207,“ᙳᑖᦪᓝgᑴij@ᑖᦪᓝgᑴij⌱4“ᙳᑖᦪ=AVG6ᡂ>7@ᑖᦪ=56ᡂ>78⊤ᙠ⊤;ᐭᡂ>⊤஺(=ᡂ>⊤஺(ᙠᡂ>⊤;ᐭ@A⊤஺@AB(=@A⊤஺@AB(ᙠ@A⊤஺@A=@@Ad17ᢥopq⌴sᦪ12@@@Aᑖᦪ@Aᙳᑖᦪᓝgᑴtᦪ

17᡻v@A1wxyzᵨ|Ạ‘”@Aᙳᑖᦪij,@totalcoursescoreoutputSelect,computerapplicationbasiccourseresultsare:',@coursesaveragescoresas,averagescores,@curriculumtotalscore,astotalscore2)passthroughparameternameDeclare@coursesaveragescoresdecimal,@curriculumtotalscoredecimal1coursename=@execcoursesofcomputerapplicationfoundation',theaveragescoresoftheaveragecourse=@@@fractionoutput,totalscore=@coursetotalscoreoutputSelect,computerapplicationbasiccoursecurriculumscoresare:',@courses,averagescores,asaverage,@curriculumtotalscore,astotalscore