Question: urgent please help Assuming before any code is run, there are 12 rows in the employees table: How many rows will be returned by the
urgent please help

Assuming before any code is run, there are 12 rows in the employees table: How many rows will be returned by the last statement? (1 mark) Explain in your own words how you came to the number you stated and why! loaded a new session in SSMS connected to our database SET IMPLICIT TRANSACTIONS ON; COMMIT ; INSERT INTO employees (employeeNumber, lastName, first Name, email) VALUES (13, ' Smith', 'John', 'jsmith@mydomain.com' ) ; CREATE VIEW vwShowEmps AS SELECT * FROM employees; INSERT INTO employees (employeeNumber, lastName, firstName, email) VALUES (14, 'Patel', 'Ronnie', 'rpatel(mydemain.com' ) ; ROLLBACK; SELECT * FROM wwShowEmps; For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I Y S Paragraph Arial 10pt
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
