Question: Given the design of TableA & TableB below and TableA has the three records shown already inserted. After the insert statement is executed against TableB,
Given the design of TableA & TableB below and TableA has the three records shown already inserted. After the insert statement is executed against TableB, how many records will have a CreatedDate in the year
create table dbo.TableAID int,Department varcharCreateDate date
create table dbo.TableBID int, Company varchar CreateDate date
insert dbo.TableAIDDepartment,CreateDate
Values 'Finance',
HR
'Engineering',
INSERT dbo.TableBIDCompany,CreateDate
SELECT ID
Department
getdate
from dbo.TableA
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
