Question: Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to
![Problem 11.1 [4] Write a procedure to add an amount of](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f4544ce5708_39666f4544c86e5b.jpg)
Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to the deptno passed as an argument. Problem 11.2 [4] Write a T-SQL block to update the salary of the employee with a 10% increase whose empno is to be passed as an argument for the procedure. [4] Problem 11.3 Write a function to find the salary of the employee who is working in the deptno 20 (to be passed as an argument). Problem 11.4 [3] Write a function to find the nature of job of the employee whose deptno is 20(to be passed as an argument) [3] Problem 11.5 Write a T-SQL block to obtain the department name of the employee who works for deptno 30
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
