Question: Question 7 Consider the following code: CREATE TABLE Employee ( EmployeeNumber INT PRIMARY KEY, EmployeeName VARCHAR ( 2 0 ) , SalarY SMALLMONEY, Stream VARCHAR
Question
Consider the following code:
CREATE TABLE Employee
EmployeeNumber INT PRIMARY KEY,
EmployeeName VARCHAR
SalarY SMALLMONEY,
Stream VARCHAR
GO
BEGIN TRAN
INSERT INTO Employee VALUES 'Sandra', MF
BEGIN TRAN
INSERT INTO Employee VALUES 'Samantha', MS
COMMIT
ROLLBACK
GO
How many records will be inserted into the table Employee?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
