--创建数据库USE[master]GOCREATEDATABASE[test]ONPRIMARY(NAME=N'test',FILENAME=N'D:\SQL\DataBase\test.mdf',SIZE=3072KB,MAXSIZE=UNLIMITED,FILEGROWTH=1024KB)LOGON(NAME=N'test_log',FILENAME=N'D:\SQL\DataBase\test_log.ldf',SIZE=1024KB,MAXSIZE=2048GB,FILEGROWTH=10%)GOALTERDATABASE[test]SETCOMPATIBILITY_LEVEL=90GOIF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC[test].[dbo].[sp_fulltext_database]@action='enable'endGOALTERDATABASE[test]SETANSI_NULL_DEFAULTOFFGOALTERDATABASE[test]SETANSI_NULLSOFFGOALTERDATABASE[test]SETANSI_PADDINGOFFGOALTERDATABASE[test]SETANSI_WARNINGSOFFGOALTERDATABASE[test]SETARITHABORTOFFGOALTERDATABASE[test]SETAUTO_CLOSEOFFGOALTERDATABASE[test]SETAUTO_CREATE_STATISTICSONGOALTERDATABASE[test]SETAUTO_SHRINKOFFGOALTERDATABASE[test]SETAUTO_UPDATE_STATISTICSONGOALTERDATABASE[test]SETCURSOR_CLOSE_ON_COMMITOFFGOALTERDATABASE[test]SETCURSOR_DEFAULTGLOBALGOALTERDATABASE[test]SETCONCAT_NULL_YIELDS_NULLOFFGOALTERDATABASE[test]SETNUMERIC_ROUNDABORTOFFGOALTERDATABASE[test]SETQUOTED_IDENTIFIEROFFGOALTERDATABASE[test]SETRECURSIVE_TRIGGERSOFFGOALTERDATABASE[test]SETDISABLE_BROKERGOALTERDATABASE[test]SETAUTO_UPDATE_STATISTICS_ASYNCOFFGOALTERDATABASE[test]SETDATE_CORRELATION_OPTIMIZATIONOFFGOALTERDATABASE[test]SETTRUSTWORTHYOFFGOALTERDATABASE[test]SETALLOW_SNAPSHOT_ISOLATIONOFFGOALTERDATABASE[test]SETPARAMETERIZATIONSIMPLEGOALTERDATABASE[test]SETREAD_COMMITTED_SNAPSHOTOFFGOALTERDATABASE[test]SETREAD_WRITEGOALTERDATABASE[test]SETRECOVERYSIMPLEGOALTERDATABASE[test]SETMULTI_USERGOALTERDATABASE[test]SETPAGE_VERIFYCHECKSUMGOALTERDATABASE[test]SETDB_CHAININGOFFGO--创建表USEtestCREATETABLEemp(EMPNONUMERIC(5,0)NOTNULL,ENAMENVARCHAR(10),JOBNVARCHAR(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','SALESMAN',7698,'2001-2-20',1600,300,30);INSERTINTOEMPVALUES(7521,'WARD','SALESMAN',7698,'2001-2-22',1250,500,30);INSERTINTOEMPVALUES(7566,'JONES','MANAGER',7839,'2001-4-2',2975,NULL,20);INSERTINTOEMPVALUES(7654,'MARTIN','SALESMAN',7698,'2001-9-28',1250,1400,30);INSERTINTOEMPVALUES(7698,'BLAKE','MANAGER',7839,'2001-5-1',2850,NULL,30);INSERTINTOEMPVALUES(7782,'CLARK','MANAGER',7839,'2001-6-9',2450,NULL,10);INSERTINTOEMPVALUES(7788,'scott','ANALYST',7566,'2002-12-9',3000,NULL,20);INSERTINTOEMPVALUES(7839,'king','PRESIDENT',NULL,'2001-11-17',5000,NULL,10);INSERTINTOEMPVALUES(7844,'TURNER','SALESMAN',7698,'2001-9-8',1500,0,30);INSERTINTOEMPVALUES(7876,'ADAMS','CLERK',7788,'2003-1-12',1100,NULL,20);INSERTINTOEMPVALUES(7900,'JAMES','CLERK',7698,'2001-3-12',950,NULL,30);INSERTINTOEMPVALUES(7902,'FORD','ANALYST',7566,'2001-3-12',3000,NULL,20);INSERTINTOEMPVALUES(7934,'MILLER','CLERK',7782,'2002-01-23',1300,NULL,10);INSERTINTODEPTVALUES(10,'ACCOUNTING','NEWYORK');INSERTINTODEPTVALUES(20,'RESEARCH','DALLAS');INSERTINTODEPTVALUES(30,'SALES','CHICAGO');INSERTINTODEPTVALUES(40,'OPERATIONS','BOSTON');--1、查询所有的雇员SELECT*FROMemp--2、查询所有的部门SELECT*FROMdept--3、查询没有佣金（COMM）的所有雇员信息SELECT*FROMdbo.empWHERECOMMISNULL--4、查询薪金(SAL)和佣金(COMM)总数大于2000的所有雇员信息SELECT*FROMempWHERE(sal+ISNULL(comm,0))>2000--5、选择部门30中的雇员SELECT*FROMempWHE...
