资源描述：
《SQL_COOKBOOK_示例数据库脚本_for_SQLserver》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、SQLCOOKBOOK示例数据库脚本forSQLserver2010年8月1日17:20:53发布:madgoat 脚残心不残，拾起之前取自伟哥的SQLCOOKBOOK，准备多动手写写sql脚本，发现由于示例简单，官网没有提供示例脚本的下载，自己动手丰衣足食。其实也是从网上找的别人写的formysql的修改而成。既然改好了，留下备用，也许以后别人也会用得到。 CRATEDATABASETestCookBookDBUSETestCookBookDBCREATETABLEemp(EMPNOINTNOTNULL,ENAMEV
2、ARCHAR(32)DEFAULTNULL,JOBVARCHAR(32)DEFAULTNULL,MGRVARCHAR(32)DEFAULTNULL,HIREDATEDATETIMEDEFAULTNULL,SALintDEFAULTNULL,COMMVARCHAR(16)DEFAULTNULL,DEPTNOVARCHAR(8)DEFAULTNULL,PRIMARYKEY(EMPNO))----Dumpingdatafortableemp--INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDAT
3、E,SAL,COMM,DEPTNO)VALUES(7369,'SMITH','CLERK','7902','1980-12-17','800',NULL,'20')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7499,'ALLEN','SALESMAN','7698','1981-02-20','1600','300','30')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,
4、DEPTNO)VALUES(7521,'WARD','SALESMAN','7698','1981-02-22','1250','500','30')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7566,'JONES','MANAGER','7839','1981-04-02','2975',NULL,'20')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VA
5、LUES(7654,'MARTIN','SALESMAN','7698','1981-09-28','1250','1400','30')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7698,'BLAKE','MANAGER','7839','1981-05-01','2850',NULL,'30')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7
6、782,'CLARK','MANAGER','7839','1981-06-09','2450',NULL,'10')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7788,'SCOTT','ANALYST','7566','1982-12-09','3000',NULL,'20')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7839,'KING'
7、,'PRESIDENT',NULL,'1981-11-17','5000',NULL,'10')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7844,'TURNER','SALESMAN','7698','1981-09-08','1500','0','30')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7876,'ADAMS','CLERK',
8、'7788','1983-01-12','1100',NULL,'20')INSERTINTOemp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES(7900,'JAMES','CLERK','7698','1981-12-03','950',NULL,'30')INSERT
