文件名称:Employee, deparmet, CostCenter and Salary level
- 所属分类：
- SQL Server数据库
- 资源属性：
- [Text]
- 上传时间：
- 2022-10-06
- 文件大小：
- 3.09kb
- 下载次数：
- 0次
- 提 供 者：
- poonamsp83@gmail.com
- 相关连接：
- 无
- 下载说明：
- 别用迅雷下载，失败请重下，重下不扣分！
介绍说明－－下载内容均来自于网络，请自行研究使用
1. Using the above table structure:
a. Write a scr ipt to create the Employees table.
b. Write a scr ipt to alter the Employees table to increase the length of the [lastName] field from 50 - 60 characters
c. Create a stored procedure that takes in a parameter of a Department Name and returns all the employees’ details for the department. If no department name is passed in, return all the employees.
d. Create a scr ipt that returns each department name and the number of employees in each department.
e. Create a scr ipt that filters by department name and returns the number of Males and females in the department
f. Create a scr ipt that filters by [employNo] and returns the salary amount as well as the department name.
g. Assuming that the relationship between Employees and [salaryLevel] does not exist, create a scr ipt that returns all the employees that have a [salarylevelID] that is not in the Salary level table.
a. Write a scr ipt to create the Employees table.
b. Write a scr ipt to alter the Employees table to increase the length of the [lastName] field from 50 - 60 characters
c. Create a stored procedure that takes in a parameter of a Department Name and returns all the employees’ details for the department. If no department name is passed in, return all the employees.
d. Create a scr ipt that returns each department name and the number of employees in each department.
e. Create a scr ipt that filters by department name and returns the number of Males and females in the department
f. Create a scr ipt that filters by [employNo] and returns the salary amount as well as the department name.
g. Assuming that the relationship between Employees and [salaryLevel] does not exist, create a scr ipt that returns all the employees that have a [salarylevelID] that is not in the Salary level table.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
压缩包 : script.txt 列表