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 2011?
create table dbo.TableA(ID int,Department varchar(100),CreateDate date)
create table dbo.TableB(ID int, Company varchar(150), CreateDate date)
insert dbo.TableA(ID,Department,CreateDate)
Values (1,'Finance','5/1/2010')
,(2,'HR','2/1/2011')
,(3,'Engineering','7/5/2012')
INSERT dbo.TableB(ID,Company,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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!