Anyone able to provide some troubleshooting help for one of our learners using our Microsoft SQL Server 2012 70-461 virtual lab? Here are the details: I downloaded the file from your website: 70-461 querying sql2012. Inside the folder 03-views_tsql I ran the item SampleData, but each time I run it the same message appears: Msg 213, Level 16, State 1, Line 12 Column name or number of supplied values does not match table definition. This is the section that causes the error: Create sample sale records INSERT Sales SELECT NEWID(),1, 1, 4, 02/01/2012INSERT Sales SELECT NEWID(),2, 1, 1, 03/01/2012INSERT Sales SELECT NEWID(),3, 1, 2, 02/01/2012INSERT Sales SELECT NEWID(),2, 2, 2, 04/01/2012INSERT Sales SELECT NEWID(),3, 2, 1, 03/01/2012INSERT Sales SELECT NEWID(),4, 2, 2, 01/01/2012
Posted on: Thu, 14 Aug 2014 19:45:00 +0000
Trending Topics
Recently Viewed Topics
© 2015