Part I: Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the field values to the procedure as parameters. Problem 2. Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this: 12 employees were hired between 1970 and 1980 19 employees were hired between 1980 and 1990 etc.
Control structures
Control structures are block of statements that analyze the value of variables and determine the flow of execution based on those values. When a program is running, the CPU executes the code line by line. After sometime, the program reaches the point where it has to make a decision on whether it has to go to another part of the code or repeat execution of certain part of the code. These results affect the flow of the program's code and these are called control structures.
Switch Statement
The switch statement is a key feature that is used by the programmers a lot in the world of programming and coding, as well as in information technology in general. The switch statement is a selection control mechanism that allows the variable value to change the order of the individual statements in the software execution via search.
SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql
Part I:
Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the field values to the procedure as parameters.
Problem 2. Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this:
12 employees were hired between 1970 and 1980
19 employees were hired between 1980 and 1990
etc.
Part II:
Problem 1. Write a cursor to print a report for each employee’s salary history. Display employee’s number, last and first name, and the salary with the starting date.
Problem 2. Modify the previous problem code to make it a stored procedure that accepts employee’s last name as
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
