Explore BrainMass

# MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Using the database and tables from attached document, write queries using the SQL SELECT statement.
(Note: Select all of the data from both of your tables before you perform the following)

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

SELECT * from Job_title,Employees;
UPDATE Employees
SET Salary = Salary + (Salary * .10)
WHERE job_title_code = ;

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

SELECT * from Job_title,Employees;
UPDATE Job_title
SET Minimum_salary = Minimum Salary + 10
WHERE job_title_code = ;

3. Increase all employees' salaries by 5%.

SELECT * from Job_title,Employees;
UPDATE Employees
SET Salary = Salary + (Salary * .05);

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

DELETE from Employees
WHERE employees = ;

These problems currently have errors and will not run. Please fix

Â© BrainMass Inc. brainmass.com December 24, 2021, 5:07 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/ms-server-sql-script-problems-ms-sql-server-2003-29936

#### Solution Summary

MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 are solved.

\$2.49