I have been using SQL for a bit now but have only recently tried out Microsoft SQL server Express. I have created a database called test
and a table called idk
. then I have tried to run the following query
USE test;
INSERT INTO idk(Id, Name) VALUES ("1","Name")
But that just says
Msg 207, Level 16, State 1, Line 2 Invalid column name '1'. Msg 207, Level 16, State 1, Line 2 Invalid column name 'Name'.
Any help for using SQL with Microsoft SQL server will be appreciated.