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:
USE [PPPCars] GO INSERT INTO [CarsSchema].[Car] ([reg] ,[make] ,[model] ,[colour] ,[date]) VALUES (<reg, varchar(10),> ,<make, varchar(10),> ,<model, varchar(30),> ,<colour, varchar(10),> ,<date, date,>) GO
what the sheet is telling me to enter is basically filling in the values in this format:
("N57CPD" ,"Renault" ,"Clio Sport" ,"Red" ,"2012-01-12"
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.