Page 1 of 1
Employee ID 1 Name Department Age Salary Adam R&D 19 50000 James Finance 25 100000 Andrew Marketing 24 80000 Harry Marke
Posted: Thu Jun 02, 2022 8:31 am
by answerhappygod
- Employee Id 1 Name Department Age Salary Adam R D 19 50000 James Finance 25 100000 Andrew Marketing 24 80000 Harry Marke 1 (54 KiB) Viewed 24 times
Employee ID 1 Name Department Age Salary Adam R&D 19 50000 James Finance 25 100000 Andrew Marketing 24 80000 Harry Marketing 23 75000 5 5 Helen Finance 30 120000 Create a stored procedure that will take the Employee ID of a person and checks if it is in the table. There are two conditions • It will create a new record if the Employee ID is not stored in the table • If the record is already in the table, it will update that 12345 234 50 2