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