资源描述：
《sql server基础查询练习(附答案)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、--创建数据库USE[master]GOCREATEDATABASE[test]ONPRIMARY(NAME=N'test',FILENAME=N'D:SQLDataBasetest.mdf',SIZE=3072KB,MAXSIZE=UNLIMITED,FILEGROWTH=1024KB)LOGON(NAME=N'test_log',FILENAME=N'D:SQLDataBasetest_log.ldf',SIZE=1024KB,MAXSIZE=2048GB,FILEGROWTH=10%)GOALTERDATABASE[test]SE
2、TCOMPATIBILITY_LEVEL=90GOIF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC[test].[dbo].[sp_fulltext_database]@action='enable'endGOALTERDATABASE[test]SETANSI_NULL_DEFAULTOFFGOALTERDATABASE[test]SETANSI_NULLSOFFGOALTERDATABASE[test]SETANSI_PADDINGOFFGOALTERDATABASE[t
3、est]SETANSI_WARNINGSOFFGOALTERDATABASE[test]SETARITHABORTOFFGOALTERDATABASE[test]SETAUTO_CLOSEOFFGOALTERDATABASE[test]SETAUTO_CREATE_STATISTICSONGOALTERDATABASE[test]SETAUTO_SHRINKOFFGOALTERDATABASE[test]SETAUTO_UPDATE_STATISTICSONGOALTERDATABASE[test]SETCURSOR_CLOSE_ON_COMMIT
4、OFFGOALTERDATABASE[test]SETCURSOR_DEFAULTGLOBALGOALTERDATABASE[test]SETCONCAT_NULL_YIELDS_NULLOFFGOALTERDATABASE[test]SETNUMERIC_ROUNDABORTOFFGOALTERDATABASE[test]SETQUOTED_IDENTIFIEROFFGOALTERDATABASE[test]SETRECURSIVE_TRIGGERSOFFGOALTERDATABASE[test]SETDISABLE_BROKERGOALTERD
5、ATABASE[test]SETAUTO_UPDATE_STATISTICS_ASYNCOFFGOALTERDATABASE[test]SETDATE_CORRELATION_OPTIMIZATIONOFFGOALTERDATABASE[test]SETTRUSTWORTHYOFFGOALTERDATABASE[test]SETALLOW_SNAPSHOT_ISOLATIONOFFGOALTERDATABASE[test]SETPARAMETERIZATIONSIMPLEGOALTERDATABASE[test]SETREAD_COMMITTED_
6、SNAPSHOTOFFGOALTERDATABASE[test]SETREAD_WRITEGOALTERDATABASE[test]SETRECOVERYSIMPLEGOALTERDATABASE[test]SETMULTI_USERGOALTERDATABASE[test]SETPAGE_VERIFYCHECKSUMGOALTERDATABASE[test]SETDB_CHAININGOFFGO--创建表USEtestCREATETABLEemp(EMPNONUMERIC(5,0)NOTNULL,ENAMENVARCHAR(10),JOBNVAR
7、CHAR(9),MGRNUMERIC(5,0),HIREDATEDATETIME,SALNUMERIC(7,2),COMMNUMERIC(7,2),DEPTNONUMERIC(2,0),)CREATETABLEdept(DEPTNONUMERIC(2),DNAMENVARCHAR(14),LOCNVARCHAR(13),)--插入数据INSERTINTOEMPVALUES(7369,'SMITH','CLERK',7902,'2000-12-17',800,NULL,20);INSERTINTOEMPVALUES(7499,'allen','SAL
8、ESMAN',7698,'2001-2-20',1600,300,30);INSERTINTOEMPVALUES(7521
