MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003
Not what you're looking for?
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
Purchase this Solution
Solution Summary
MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 are solved.
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Basic Networking Questions
This quiz consists of some basic networking questions.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Javscript Basics
Quiz on basics of javascript programming language.