Zoom
498546213
567890345
890008978
987987987
999887777
Picture 7.1
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 co 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
Bdate
Address
Sex Salary
Super_ssn Dno
Bary 0 Oral 123678890 1977-06-25 245 Gift, Super, TX 638 Voss, Houst...
M
Fran... T
Tim
R
Kim
P
Dan D
Jenn... S
Ahmad V
Alicia
J
Wong 333445555
1955-12-08
Rock 498546213
2001-01-15
678 Come, Well....
Poss... 567890345
1991-02-27
321 Mount, Six, TX
Dattar 890008978 2002-08-18 1802 Dear, Deer....
Wall... 987654321
1941-06-20
291 Berry, Bellair...
Jabbar 987987987
1969-03-29 980
Dallas, Hous...
Zelaya 999887777
1968-01-19
3321 Castle, Spri...
Picture 8.1
M
55000.00 987654321 4
40000.00 888665555 5
M
F
M
60000.00
987654321 4
35000.00 987654321 4
40000.00 987654321 4
F
M
F
43000.00
888665555 4
30000.00 987654321 4
30000.00 987654321 4
+ 85%
TeamViewer
Close
ENG INTL
5:40 pm
18/03/2023
