已阅读5页，还剩45页未读， 继续免费阅读
版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领
文档简介
数据库系统原理实验报告目录实验1SQLSERVER管理工具的使用1实验2数据定义5实验3数据更新（插入、修改和删除）15实验4数据查询17实验5数据完整性28实验6数据控制38实验7视图的应用43A1A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A161A17/A1850A17实验1SQLSERVER管理工具的使用A19A20A21A22A23A24A251A26A27A28SQLSERVERA29A30A31A22A32A332A26A27A28A34A35A36A37A31A22A38A39A40A41A42A433A26A27A28A44A45A46A47A31A22A38A39A40A41A42A434A26A27A28A29A30A36A37A31A22A38A39A40A41A42A435A26A48A49A50A51A52A53A48A54A55A19A56A38A39A57A586A59A60A40A41SQLSERVERA61A62A63A64A65TRANSACTSQLA66A67A68A20A69A70A71A721A26A57A58SQLSERVERA73A74A75A39A32A33A22A76A20A77A78A24A252A26A57A58SQLSERVERA79A80A22A81A82A70A83A84A853A26A57A58SQLSERVERA73A86A78A22A87A24A88A894A26A48A49A50A51A20A90A65A49A50A51A48A54A55A19A56A38A39A57A585A26A57A58A91A44A45A46A47A31A92A93A94SQLA95A96A22A42A43A97A20A69A70A98A991A26A32A33SQLSERVER2000A100A50A76A77A78A101A102A103A104A105A19A56A106A107A75A39A22SQLSERVER2000A1082A26A109A41A34A35A36A37A31A110A111A112A113A114A115A22PUBSA49A50A51A108A1161A117A118A119SQLSERVERA29A30A36A37A31A108A120A121A122A123A124A125A126MICROSOFTSQLSERVERA29A30A36A37A31A127A128A123A122SQLSERVERA29A30A36A37A31A127A103A118A119A122SQLSERVERA29A30A36A37A31A127A103A129A130A131A132A133A134A94A22A29A30A31A135A108A13611A137A138SQLSERVERA139A140A141A142A143A1162A117A118A119A34A35A36A37A31A108A120A121A122A123A124A125A126MICROSOFTSQLSERVERA34A35A36A37A31A127A128A123A122SQLSERVERENTERPRISEMANAGERA127A144A145A146A147A148A149A150A151A152A153A154A155A156A157A158A159A162A17/A1850A17A13612A137A138A160A161A141A142A143A1163A117A91A34A35A36A37A31A22A162A163A21A131A92A164A123A49A50A51A103A165A166PUBSA129A164A123A103A167A168A169A170A49A50A51A22A171A55A48A54A103A172A90A20A173A174A20A175A176A121A125A20A177A178A65A179A167A180A108A1164A117A104A92A122A90A127A103A181A168A169PUBSA49A50A51A22A171A55A90A116A182A183A112A113A90A65A41A184A90A117A103A91A185A186A41A184A90TITLESA187A188A103A104A92A170A90A103A189A190A191A192A193A194A103A195A169A196A197A198A189A103A93A94A122A128A123A90A199A200A201A171A55A94A127A198A189A202A103A128A123A170A90A103A44A203A53A98A99A1085A104A92A90TITLESA103A189A190A191A192A193A194A103A195A169A196A197A198A189A103A93A94A122A204A205A90A127A198A189A202A103A44A203A53A206A207A103A129A130A131A170A90A22A206A207A1086A41A208A209A22A42A43A44A203PUBSA49A50A51A92A22A53A210A41A184A90A103A129A130A131A211A212A90A22A206A207A1083A26A109A41A44A45A46A47A31A110A111A112A113A114A115A22PUBSA49A50A51A22A90A1161A117A118A119SQLSERVERA44A45A46A47A31A120A121A122A123A124A125A126MICROSOFTSQLSERVERA44A45A46A47A31A127A128A123A122SQLSERVERA44A45A46A47A31A127A103A129A186A112A113A36A37A213SAA22A81A82A214A215A166SQLSERVERA108A13613A216A217SQLSERVERA139A140A1432A40A41A112A113A175A176A121A125A116SP_TABLESA65SP_HELPA117A44A203A112A113A114A115A22PUBSA49A50A51A92A22A90TITLESA22A206A207A218A219A144A145A146A147A148A149A150A151A152A153A154A155A156A157A158A159A163A17/A1850A17A91A44A45A46A47A31A22A220A221A222A223A92A194A224A172A225SQLA226A220A221A227USEPUBSGOSP_TABLESTITLESGOSP_HELPTITLESGOA228A122F5A127A194A229A230A189A190A231A232A233A92A22A122A127A228A234A93A94SQLA44A45A13614A235A236A237A238A239A143A240A236A241A242A243A244A245A246A2473A109A41SQLA220A221A44A203A112A113A114A115A22PUBSA49A50A51A92A22A90TITLESA22A94A218A219SELECTFROMTITLESGOA144A145A146A147A148A149A150A151A152A153A154A155A156A157A158A159A164A17/A1850A17A13615A235A236A237A238A239A143A240A248A249SQLA236A2374A26A91A44A45A46A47A31A92A128A123A122A66A67A127A198A189A103A40A41SQLSERVERA61A62A63A64A65TRANSACTSQLA66A67A108A144A145A146A147A148A149A150A151A152A153A154A155A156A157A158A159A165A17/A1850A17实验2数据定义A19A20A21A22A65A24A251A26A57A58SQLSERVERA49A50A51A22A250A251A206A207A65A252A37A206A207A1082A26A57A58A90A22A206A207A253A254A1083A26A57A58SQLSERVERA22A38A39A49A50A255A4A1084A26A59A60A91A34A35A36A37A31A92A41A0A49A50A51A65A90A1085A26A59A60A40A41TSQLA95A96A41A0A49A50A51A65A90A1086A26A59A60A1A2A3A5A68A20A69A70A71A721A26A6A7A8A9A10A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A85A183A21A27A28A29A30A17CREATEDATABASEA77A31A16A17A18A902A32A11A12A13A14A15A19A20A6A8A196A13A14A15A33A34A127A35A36A98A211A11A12A13A14A15A16A17A18A99A34A13A14A15A37A38A98A214A215A16A37A38A34A214A37A16A37A38A34A21A207A39A40A42A43A44A42A43A16A45A46A99A47A48A49A13A14A16A50A51A903A32A8A196A13A14A15A203A52A53A54A55A56A44A203A52A16A57A55A16A58A59A85A224A6A60A61SQLSERVERA16A62A17A13A14A63A195A85A56A11A12A13A14A15A16A55A904A32A60A61A62A17A16A11A12A13A14A15A47A55A16A45A64A905A60A61A226A65A66A67A47A68A226A65A66A67A79A34A69A70A71A72A160A35A73A74A75A24A25A22A23A85A76A13A14A15A33A78A104STUDENTA109A85A215A80A37A38A7810MBA85A214A37A7850MBA85A13A14A15A81A82A42A43A85A42A43A45A46A21A2195A230A231A83A42A43A232A233A84A50A51A215A80A782MBA85A214A37A86A42A43A875MBA85A2191MBA42A43A90A13A14A15A16A88A89A50A51A33A78A104STUDENT_DATAA109,A191A25A50A51A33A78A104STUDENT_DATAMDFA85A48A131A91A92A78A104ESQL_DATAA109A90A233A84A50A51A16A88A89A50A51A33A78A104STUDENT_LOGA109,A191A25A50A51A33A78A104STUDENT_LOGLDFA109A85A48A131A91A92A78A104ESQL_DATAA109A90A57A13A14A55A16A58A59A93A94A181A9521STUDENTA96A97A100A101A102A103A96A105A106A107A108A110A111A112A113A114A115A116A117A118A119A120A121A122SNOCHAR8NOTNULLA123A124A125A124A126SNAMECHAR8NOTNULLA124A125A128A129SEXCHAR2NULLA124A125A130A132NATIVECHAR20NULLA133A134BIRTHDAYSMALLDATE4NULLA124A125A135A125A136A137DNOCHAR6NULLA124A125A138A139A140A141A142A126A143A144A145A146SPNOCHAR8NULLA147A148A149A150A143A144A145A146CLASSNOCHAR4NULLA151A152A126ENTIMESMALLDATE4NULLA124A125A153A154A155A156HOMEVARCHAR40NULLA124A125A157A158A159A161TELVARCHAR40NULLA124A125A162A141A163A164A9622COURSEA96A97A165A166A102A103A96A105A106A107A108A110A111A112A113A114A115A116A117A118A119A120A121A122CNOCHAR10NOTNULLA123A167A168A142A126SPNOCHAR8NULLA147A148A149A150A143A144A145A146CNAMECHAR20NOTNULLA167A168A129A169CTNOTINYINT1NULLA167A168A170A171A142A126A143A144A145A146EXPERIMENTTINYINT1NULLA172A173A155A174LECTURETINYINT1NULLA175A176A177A178A179A180A182A184A185A186A187A188A189A190A192A193A194A197A198A199A2006A201/A20250A201SEMESTERTINYINT1NULLA204A176A177A205CREDITTINYINT1NULLA176A206A177A208A20923STUDENT_COURSEA209A210A212A213A216A217A218A220A209A221A222A223A225A227A228A229A234A235A236A237A238A239A240A241A242A243SNOCHAR8NOTNULLA244A177A245A177A246TCIDSMALLINT2NOTNULLA244A247A176A248A246SCORETINYINT1NULLA249A250A251A252A25324TEACHERA253A254A255A29A0A1A253A7A8A2A3A4A12A13A14A15A16A5A6A9A20A21A22A23TNOCHAR8NOTNULLA32A82A10A11A17TNAMECHAR8NOTNULLA82A10A18A19SEXCHAR2NULLA82A10A24A25BIRTHDAYSMALLDATE4NULLA82A10A26A250A27A28DNOCHAR6NULLA82A10A30A31A33A34A11A17A49A50A35A52PNOTINYINT1NULLA82A10A36A37A38A36A39A11A17HOMEVARCHAR40NULLA82A10A40A41A42A43ZIPCODECHAR6NULLA86A44A11A45TELVARCHAR40NULLA66A34A46A47EMAILVARCHAR40NULLA46A67A86A48A25325TEACHER_COURSEA253A254A255A29A51A53A53A253A7A8A2A3A4A12A13A14A15A16A5A6A9A20A21A22A23TCIDSMALLINT2NOTNULLA32A79A54A11A17TNOCHAR8NULLA82A10A11A17A49A50A35A52SPNOCHAR8NULLA55A56A57A45A49A50A35A52CLASSNOCHAR4NULLA58A59A60CNOCHAR10NOTNULLA69A61A62A60A63A64A65A68SEMESTERCHAR6NULLA70A71SCHOOLYEARCHAR10NULLA70A72CLASSTIMEVARCHAR40NULLA73A69A74A75CLASSROOMVARCHAR40NULLA73A69A76A77WEEKTIMETINYINT1NULLA93A78A69A74A801A81A196A83A84A85A871A88A89A90A91A92A94A95A196A83A84A85A87A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A1127A113/A11450A113A11521A116A117A80A118A119A11522A80A118A119A120A121A122A123A124A11523A117A125STUDENTA80A118A1192A88A89SQLA126A127A196A83A84A85A87CREATEDATABASESTUDENTONNAMESTUDENT_DATA,FILENAMEESQL_DATASTUDENT_DATAMDF,SIZE10MB,A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A1128A113/A11450A113MAXSIZE50MB,FILEGROWTH10LOGONNAMESTUDENT_LOG,FILENAMEESQL_DATASTUDENT_LOGLDF,SIZE2MB,MAXSIZE5MB,FILEGROWTH1MBA11524CREATEDATABASEA128A129A130A117A80A118A1192A196A83A1311A88A89A90A91A92A94A95A196A83A131A11525A116A117A132A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A1129A113/A11450A113A11526A132A133A134A135A11527A136A137A138A139A140A1412A88A89SQLA126A127A196A83A131CREATETABLESTUDENTSNOCHAR8PRIMARYKEY,A70A60A142A65SNAMECHAR8NOTNULL,A143A144SEXCHAR2,A121A145NATIVECHAR20,A146A147BIRTHDAYSMALLDATETIME,A148A149A150A71DNOCHAR6,A151A152A153A154A62A60A64A65SPNOCHAR8,A155A156A157A158A64A65CLASSNOCHAR4,A58A59A60ENTIMESMALLDATETIME,A137A159A74A75HOMEVARCHAR40,A160A161A162A163TELVARCHAR40A164A154A165A123CREATETABLECOURSECNOCHAR10PRIMARYKEY,A69A61A62A60A142A65CNAMECHAR20NOTNULL,A69A61A144A166A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A11210A113/A11450A113SPNOCHAR8,A155A156A157A158CTNOTINYINT,A69A61A167A168A62A60A64A65LECTURETINYINT,A169A170A70A74EXPERIMENTTINYINT,A171A172A74A80SEMESTERTINYINT,A173A69A70A71CREDITTINYINTA69A61A70A174A11528A130A117STUDENTA132A11529A130A117COURSEA132CREATETABLETEACHERTNOCHAR8PRIMARYKEY,A175A176A62A60A142A65TNAMECHAR8NOTNULL,A175A176A143A144SEXCHAR2,A175A176A121A145BIRTHDAYSMALLDATETIME,A148A149A150A71DNOCHAR6,A151A152A153A154A62A60A64A65PNOTINYINT,A177A178A179A177A166A62A60HOMEVARCHAR40,A160A161A162A163ZIPCODECHAR6,A180A181A62A158TELVARCHAR40,A164A154A165A123EMAILVARCHAR40A165A182A180A183A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A11211A113/A11450A113A115210A130A117TEACHERA132CREATETABLESTUDENT_COURSESNOCHAR8,A70A149A70A60TCIDSMALLINT,A73A69A62A60SCORETINYINT,A70A149A184A185PRIMARYKEYSNO,A142A65TCIDA142A65A1152131A130A117STUDENT_COURSEA132CREATETABLETEACHER_COURSETCIDSMALLINTPRIMARYKEY,A73A69A62A60A142A65TNOCHAR8,A175A176A62A60A64A65SPNOCHAR8,A155A156A157A158A64A65CLASSNOCHAR4,A58A59A60CNOCHAR10NOTNULL,A69A61A62A60A64A65SEMESTERCHAR6,A70A71SCHOOLYEARCHAR10,A70A72CLASSTIMEVARCHAR40,A73A69A74A75CLASSROOMVARCHAR40,A73A69A76A77A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A11212A113/A11450A113WEEKTIMETINYINTA93A78A69A74A80A115212A130A117TEACHER_COURSEA1323A239A186A1311A88A89A90A91A92A94A95A239A186A131A115213STUDENTA132A133A134A1352A88A89SQLA126A127A239A186A131ALTERTABLETEACHERALTERCOLUMNEMAILVARCHAR50NULLEXECSP_RENAMETEACHEREMAIL,A165A182A180A183,COLUMNA115214ALTERTABLEA128A129A187A188A1323A88A89SQLA126A127A189A190A131DROPTABLETEACHERA96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A11213A113/A11450A1133A88A89SQLA126A127A83A191A192A189A190A193A1941A195A131STUDENTA197A198SNAMEA83A191A199A200A193A194CREATECLUSTEREDINDEXMYINDEXONSTUDENTSNAME2A189A190A131STUDENTA197A198SNAMEA197A199A200A193A194MYINDEXDROPINDEXSTUDENTMYINDEX3A195STUDENTA131A201A202A203A204A205A83A191A206A207A193A194A208A247A203A195STUSNAMEA209CREATEUNIQUEINDEXSTUSNAMEONSTUDENTSNAMEASC4A195STUDENT_COURSEA131A201A210A211A204A205A212A213A214A211A215A205A83A191A206A207A193A194A208A247A203A195SCSNOCNOA209A216CREATEUNIQUEINDEXSCSNOCNOONSTUDENT_COURSESNOASC,CNODESCA251A217A218A219A220A91A2211A81A84A85A87A222A223A2081A209A196A83A89A224A225A226A227A228A197A84A85A87A229A84A85A87A203A195YGKQA229A230A231A232A233A19510MBA229A234A232A19550MBA229A84A85A87A235A236A237A238A229A237A238A240A241A242A2015A243A244A245A237A238A246A248A249A250A252A230A231A1952MBA229A234A232A253A237A238A2545MBA229A2011MBA237A238A216A84A85A87A197A255A31A250A252A203A212A0A94A250A252A203A3A1A89A23A2A5A216A2082A209A84A85A87YGKQA138A4A225A226A197A6A7A212A8A228A194A9A6A7A229A35YGKQA138A4A10A1982A38A131A181JBQKA181A225A226A169A11A12A13A131A246QQLXA181A8A228A6A7A131A216A55A131A197A14A15A16A13121A212A13122A127A17A181A13121JBQKA208A225A226A169A11A12A13A131A14A15A209A18A19A203A18A19A194A9A18A19A20A21A22A202A225A226A211A202A203A8A228A24A25A8A228A26A84A8A228A194A9A8A228A94A27CHARCHARDATETIMEINTCHARCHAR48420A69A28A13122QQLXA208A8A228A194A9A6A7A131A14A15A209A18A19A203A18A19A194A9A18A19A20A21A22A202A8A228A194A9A8A228A203A29A8A228A30A32CHARCHARCHAR4820A69A28A55A131A197A84A85A33A34A16A13123A21224A127A17A181A13123JBQKA208A225A226A169A11A12A13A112A36A209A37A226A211A202A203A8A228A24A25A8A228A26A84A8A228A194A9A8A228A94A27001A39A402006090331A41A42002A43A442006091222A45A42003A46A472006090353A48A226004A43A49A402006091021A41A42005A50A512006091612A45A42A13124QQLXA208A8A228A194A9A6A7A112A36A209A8A228A194A52A8A228A203A29A8A228A30A321A41A42A11A53A205A54A56A1151A26A57A58A22912A26A27A59A60A61A62A2292A26A142A63A27A64A94A65A612A45A4212A26A27A59A60A61A62A2292A26A142A63A27A64A94A65A61A96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111A11214A113/A11450A1133A48A226A66A67A68A254A122A201A48A226A70A944A71A254A73A72A74A63A75A24A251A233A24A76A254A772A81A73A90A91A92A94A95A78A196A83A212A189A190A84A85A87A212A84A85A131A2081A209A73A90A91A92A94A95A78A196A83A197YGKQA84A85A87A216A2082A209A73A90A91A92A94A95A78A189A190YGKQA84A85A87A216A2083A209A73A90A91A92A94A95A78A222A52A196A83A131JBQKA212QQLXA216A2084A209A73A90A91A92A94A95A189A190A196A83A197JBQKA212QQLXA131A2163A81A79A80A81A82A83A84A85A86A87A88A89A90A91A88A89A92A981A99A93TSQLA94A95A86A87A88A89A90YGKQA96A982A99A97A93TSQLA94A95A86A87JBQKA91QQLXA92A964A100A86A87A196A1011A143A88A89A90YGKQA85JBQKA92A102A104A103A105A106A88A109A107A108A86A87A110A111A113A114A116A196A101A117A118A119A120A143KCZCCJ_INDEXA962A97A93A121A123A124A125A126A128SP_HELPINDEXA80A129JBQKA92A130A102A196A101A131A132A963A93SQLA94A95A133A134KCVC_INDEXA96A135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15415A155/A15650A155实验3数据更新（插入、修改和删除）A110A157A158A102A91A159A1601A100A161A162A79A163A164A165A166A84A85A167A92A168A170A171A178A157A239A172A91A133A134A88A89A173A252A962A100A161A162A97A93TSQLA94A95A167A92A168A170A171A178A157A239A172A91A133A134A88A89A173A252A963A100A174A175TSQLA94A95A167A92A88A89A90A173A252A102A176A177A179A180A182A183A96A184A157A185A186A187A1881A100A174A175A92A102A189A190A173A252A117A211A88A89A102A171A178A157A239A172A91A133A134A117A167A92A88A89A102A173A252A191A192A79A163A164A165A166A84A85A168A170A117A193A191A192A195TSQLA94A95A185A197A962A100A198A199TSQLA85A93A200A167A92A88A89A168A170A171A178A98INSERTA99A157A239A172A98UPDATEA99A91A133A134A98DELETEA201TRANCATETABLEA99A203A204A102A93A206A963A100A174A175A97A93TSQLA94A95A79A167A92A88A89A168A170A171A178A157A239A172A207A133A134A208A117A231A79A163A164A165A166A84A85A173A252A92A88A89A176A177A117A182A183A189A209A212A96A210A157A185A186A213A2141A100A79A163A164A165A166A84A85A167A88A89A90STUDENTA85A102A92A168A170A171A178A157A133A134A88A89A102A173A252A961A79A163A164A165A166A84A102A215A216A158A217A85A218A219A88A89A90STUDENTA117A220A221A92A222A218A219A117A223A224A225A226A88A89A90A102A227A228A167A229A117A230A92A157A232A233A157A124A125A126A128A157A234A235A91A236A223A237A962A238A85A104A92A109A117A240A224A225STUDENTA88A89A90A102A227A228A92A98A241A242A121A123A92A91A93A243A92A99A117A79A244A192A93A243A92STUDENTA143A245A117A238A85A226A92A117A246A247A248A249A250A251A117A253A225A254A255A151A246A117A75A170A104A110A219A92A155A156A0A227A228A170A109A151A246A145A117A110A219A226A92A117A222A67A92A85A217A178A68A1A2A112A217A96A23331A67A92A85A171A178A88A893A79A163A164A165A166A84A85A133A134A88A89A90STUDENTA85A102A92A88A89A96A79A110A219A102A92STUDENTA85A117A238A86A240A159A133A134A102A170A117A246A247A248A249A250A251A117A253A225A254A255A151A246A117A75A170A104A133A134A109A151A246A145A117A79A110A219A102A133A134A167A71A3A85A0A73A104A207A109A96A23332A133A134A92A85A102A88A892A97A93SQLA94A95A171A178A157A239A172A91A133A134A92A88A89A74A4A100A5SQLSERVERA80A81A82A83A84A117A222A192A121A123A165A166A111SAA102A6A7A8A9A221SQLSERVERA96A76A10A75A170A11A224SQLA94A95A181A135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15416A155/A15650A155INSERTINTOSTUDENTVALUES02080001,A117A12,A119,A120A13,198512,610000,080605,0201,200291,A120A13A14A15A16A17A18A19A2011,8305670A2133INSERTA103A22A23A24A25A26A27A28A29UPDATESTUDENTSETNATIVEA129A15WHERENATIVEA120A13A2134UPDATEA103A22A30A31A24A25A28A29DELETESTUDENTWHERENATIVEA129A15A2135DELETEA103A22A32A33A24A25A28A29A251A157A185A186A252A164A51A82A89A78A110A246A79A102A111A34A35A105A36A37A117A167A185A1862A227A86A87A88A89A90YGKQA102A38A92A168A170A88A89A189A190A173A252A96A135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15417A155/A15650A155实验4数据查询A110A157A158A102A39A159A1601A100A198A199SELECTA94A95A102A77A40A94A206A962A100A198A199A80A80A81A102A92A41A963A100A198A199A8A9A80A81A102A92A41A964A100A198A199SELECTA94A95A102A123A42A81A88A102A252A93A91A97A93A43A206A965A100A198A199SELECTA94A95A102GROUPBYA91ORDERBYA80A95A102A252A93A91A97A93A43A206A96A184A157A185A186A187A1881A100A174A175SELECTA94A95A102A77A40A94A206A44A45A962A100A174A175SELECTA94A95A102A75A170A43A206A963A100A174A175A80A80A81A102A92A41A43A206A964A100A174A175SELECTA94A95A102A123A42A81A88A102A252A93A965A100A174A175SELECTA94A95A102GROUPBYA91ORDERBYA80A95A102A252A93A96A210A157A185A186A213A214A74A4A100A5SQLSERVERA80A81A82A83A84A117A222A192A121A123A165A166A111SAA102A6A7A8A9A221SQLSERVERA96A192A11A227A228A80A81A83A79A80A81A82A83A84A85A75A170A961A84A246A80A81SELECTSNO,SNAME,SEX,BIRTHDAYFROMSTUDENTA2141A46A47A48A49SELECTSNO,SNAME,CASTGETDATEBIRTHDAYASINT/365ASAGEFROMSTUDENTA2142A46A47A48A49A25A50A52A53A54A55A56A54AGESELECTSNO,SNAME,SEX,BIRTHDAYFROMSTUDENTWHEREDNO610000A135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15418A155/A15650A155A2143A46A47A48A49SELECTSNO,SNAME,BIRTHDAYFROMSTUDENTWHERESPNO080605ANDCLASSNO0201A2144A46A47A48A49SELECTSNO,SNAME,SEX,BIRTHDAYFROMSTUDENTWHEREBIRTHDAY1985/01/01A2145A46A47A48A49SELECTFROMTEACHERWHEREPNO4A2146A46A47A48A49SELECTSNO,SNAMEFROMSTUDENTWHERESNAMELIKEA134A135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15419A155/A15650A155A2147A46A47A48A49SELECTSNO,SNAMEFROMSTUDENTWHERESNAMELIKEA134_A2148A46A47A48A49SELECTSNO,SNAMEFROMSTUDENTWHERESNAMELIKEA134A117A2149A46A47A48A49SELECTSNO,SNAME,SEX,BIRTHDAYFROMSTUDENTWHEREDNO610000ANDBIRTHDAY1985/01/01A21410A46A47A48A49SELECTFROMSTUDENTWHERENATIVENOTLIKEA120A13A21411A46A47A48A49SELECTFROMSTUDENTA135A136A137A139A140A141A144A145A146A147A148A149A150A151A152A153A15420A155/A15650A155WHERECASTGETDATEBIRTHDAYASINTBETWEEN6570AND7300A21412A46A47A48A49SELECTSNO,SNAME,SEX,SPNOFROMSTUDENTWHERESPNOIN080604,080605,080602A21413A46A47A48A49SELECTSNO,SNAME,SEX,BIRTHDAYFROMSTUDENTORDERBYBIRTHDAYASCA21414A46A47A48A49SELECTSNO,SNAME,SEX,BIRTHDAY,DNOFROMSTUDENTORDERBYDNO,BIRTHDAYDESCA21415A46A47A48A49A135A136A137A139A140A141A144A145A146A147A148A149A150A
温馨提示
- 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 概率论与数理统计练习题(附答案)
- 2025年抗乙肝病毒药物项目发展计划
- 2025年安全培训考试练习题完整及答案解析
- 公路水运工程试验检测题库及答案
- 2025数学教师年度考核个人工作总结10篇
- 2025年住院医师考试-耳鼻咽喉科住院医师历年参考题库含答案解析(5卷套题【单项选择题100题】)
- 6-综合训练实际问题与方程（一）
- 离婚协议书债务豁免协议2025年
- 事业单位的劳动合同书(2025版)
- 人力资源劳动合同范本2025年
- 音乐版权授权书
- 2023年武汉市新型智慧城市“十四五”规划
- 企业车辆进出及停放管理办法
- 车辆分期买卖合同协议书
- 做一名的财务主管
- 《文体疗法学》教学大纲
- 对外汉语拼音教学课件
- GB/T 5210-2006色漆和清漆拉开法附着力试验
- GB/T 30323-2013二手车鉴定评估技术规范
- GB/T 15079.12-1994钼精矿化学分析方法油和水分总含量的测定
- 湖北大学物理化学试题及答案(B)
评论
0/150
提交评论