Hi, I've had a look around the forums but I couldn't find a specific answer to my query. I'm following a worksheet I was given from university. We have just started working on SQL and databases and on the worksheet it uses SQL 2008 Server Management Studio. The version I had couldn't design tables or database or something so I had to get 2012. I followed the sheet but when I tried to add data to the table using the information from the sheet, I had errors such as:
Msg 102, Level 15, State 1, Line 9 Incorrect syntax near '<'.
It even throws the error with the code/data that is there to begin with. The current code is:
INSERT INTO [CarsSchema].[Car]
what the sheet is telling me to enter is basically filling in the values in this format:
I'm really confused as this is the first time I have touched this sort of stuff and when I do look for help, all the tech terms are used and I can really see a problem that quite fits these parameters. Help is very much appreciated.