I am working through an SQL Server 2008 book. I am to the query section. I have copied the query below, word for word (I believe), but the system is showing a problem at line 10.
This is the first query I have tried to create. I don't see what the problem is?
USE BankOfFees GO CREATE TABLE Customers (customer_id INT NOT NULL, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL) GO INSERT INTO Customers VALUES (1,'Barack','Obama'), VALUES (2,'George','Bush'), VALUES (3,'Bill','Clinton') GO
Here is the error message:
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Customers' in the database.
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'VALUES'.