Question 8:
Write a proc named "updateSalary" to increase employee salary by an additional 10% salary if his/her department has performed the projects at a certain location and the old salary is below 30000.
for example: when using statements as follow to execute:
declare @location varchar(15)
set @location='Stafford'
exec updateSalary @location
then the result is follow:
Fname Minit Lname Ssn
Bary 0 Oral
Fran... T
Tim R
Bdate
Address
Sex Salary
Kim P
Dan D
123678890
1977-06-25
245 Gift, Super, TX
Wong
333445555
1955-12-08
638 Voss, Houst...
Rock
498546213
2001-01-15
678 Come, Well....
Poss... 567890345
1991-02-27
321 Mount, Six, TX
Dattar 890008978 2002-08-18
M
55000.00
Super_ssn Dno
987654321 4
M
40000.00
888665555 5
M
60000.00
987654321 4
F
1802 Dear, Deer....
M
Jenn... S
Wall... 987654321
1941-06-20
291 Berry, Bellair...
F
35000.00
987654321 4
40000.00 987654321 4
43000.00
888665555 4
Ahmad V
Alicia J
Jabbar 987987987
1969-03-29
980 Dallas, Hous...
M
Zelaya 999887777
1968-01-19
3321 Castle, Spri... F
30000.00
987654321 4
30000.00
987654321 4
Picture 8.1
Zoom
Question 9:
Create a trigger named "tr_no_insert" for the insert statement on the EMPLOYEE table. This trigger does NOT allow you to insert a new employee when his/her department is greater
99%
TeamViewer
Close
ENG
INTL
5:56 pm
18/03/2023
