Share
Explore BrainMass

MS SQL STATEMENTS

I am using Microsoft SQL Server 2000

1. Database Tables

TABLE: Employees

Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary

TABLE: Job_title

Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary

2. Queries using the SQL SELECT statement.
(Note: Select all of the data from both of your tables before you perform the following)

A. Choose a job_title_code: Increase all employees' salaries that have: job_title_code by 10%.

B. Choose a job_title_code in the job_title table. Increase the Minimum_salary and Maximum_salary for this job_title_code.

C. Increase all employees' salaries by 5%.

D. Choose an employee from the employee table, delete this employee.

Solution Preview

Select * from Job_title,Employees;
a.
Update Employees
Set Salary = Salary + (Salary * .10)
WHERE job_title_code = \"a\"; I don\'t know an example ...

$2.19