According to the CTP3 BOL the following code should work just fine, unfortunately is giving me the error message (below the code):
create table FamilyNames (
Id int identity,
[Name] varchar(30)
);
go
insert into FamilyNames values (
('Andersson'),
('Ben-Gan'),
('Carlsson'),
('Davidsen')
);
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.
Does anybody know why this code fails?
Hi,
Try
insert into FamilyNames values
('Andersson'),
('Ben-Gan'),
('Carlsson'),
('Davidsen');
Kind regards,
Wesley
|||Thanks.