Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I was given this exercise related to programming. Can somebody please explain to me how can i obtain this?. It would be necessary to create
I was given this exercise related to programming. Can somebody please explain to me how can i obtain this?. It would be necessary to create an API? What is the easiest way? Thanks!
76 I need to update a table in a SQL SERVER environment; it contains information related to employees. TABLE NAME: table_employess id employee number name last name email 1 56 Rupert Herte Ruper453@gmail.com 2 Stewie Mathy Mathy86@gmail.com 3 98 Peter Kathy Peter_crazy@gmail.com I WANT TO BE ABLE TO "SWAP" THE EMAIL FROM A GIVEN INSTANCE OF THIS TABLE AND REPLACE IT FOR A DIFFERENT EXISTING ONE. EXAMPLE: I want the final user to select a specific employee by introducing the employee number and then, i want the system to display all the different emails (without including the email of this particular employee), select the new email and save the changes TAKE A LOOK: SYSTEM SHOULD ASK THE USER TO INTRODUCE THE NUMBER OF THE EMPLOYEE (IN THIS CASE THE USER ENTERED NUMBER "56") SINCE THE USER CHOSE NUMBER "56" ONLY EMAILS FROM EMPLOYEES "76" AND "98" SHOULD BE DISPLAYED: Mathy86@gmail.com Peter_crazy@gmail.com ONCE THE USER SELECTED ONE OF THE EMAILS SHOWN ABOVE, HE SHOULD CLICK ON "SAVE" AND FINALLY THE TABLE FROM SQL SERVER SHOULD BE UPDATED: lid 1 employee number 56 76 98 name Stewie Stewie Peter last name Mathy Mathy Kathy emaill Mathy86@gmail.com Mathy86@gmail.com Peter_crazy@gmail.com 2 3 76 I need to update a table in a SQL SERVER environment; it contains information related to employees. TABLE NAME: table_employess id employee number name last name email 1 56 Rupert Herte Ruper453@gmail.com 2 Stewie Mathy Mathy86@gmail.com 3 98 Peter Kathy Peter_crazy@gmail.com I WANT TO BE ABLE TO "SWAP" THE EMAIL FROM A GIVEN INSTANCE OF THIS TABLE AND REPLACE IT FOR A DIFFERENT EXISTING ONE. EXAMPLE: I want the final user to select a specific employee by introducing the employee number and then, i want the system to display all the different emails (without including the email of this particular employee), select the new email and save the changes TAKE A LOOK: SYSTEM SHOULD ASK THE USER TO INTRODUCE THE NUMBER OF THE EMPLOYEE (IN THIS CASE THE USER ENTERED NUMBER "56") SINCE THE USER CHOSE NUMBER "56" ONLY EMAILS FROM EMPLOYEES "76" AND "98" SHOULD BE DISPLAYED: Mathy86@gmail.com Peter_crazy@gmail.com ONCE THE USER SELECTED ONE OF THE EMAILS SHOWN ABOVE, HE SHOULD CLICK ON "SAVE" AND FINALLY THE TABLE FROM SQL SERVER SHOULD BE UPDATED: lid 1 employee number 56 76 98 name Stewie Stewie Peter last name Mathy Mathy Kathy emaill Mathy86@gmail.com Mathy86@gmail.com Peter_crazy@gmail.com 2 3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started