Hello,
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'.