which of the following statements is true in regards to the update statement Con

Question

which of the following statements is true in regards to the update statement Consider the following TSQL update statement: UPDATE EMPLOYEES SET EMPLOYEES.SALARY = PAYROLL.SALARY FROM PAYROLL, EMPLOYEES WHERE EMPLOYEES.ID = PAYROLL.EMP-.ID Which of the following statements is TRUE in regards to the update statement? A O This statement will result in an error. B This statement will update both the EMPLOYEES and PAYROLL tables. C O This statement will never update any rows. D This statement will update the SALARY column in the EMPLOYEES table.

Explanation / Answer

Ans) D This statement will update the salary column in the Employees table.

Reason:

Update command is used to update the data in the table

Here we are updating the salary column in the Employees table

____________Thank You

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.