error in code!

sabra · June 16th, 2010, 11:44 AM

CREATE TABLE BLOBTest
(
BLOBID int IDENTITY NOT NULL,

BLOBData varbinary(max) NOT NULL

BLOBI int NULL
)
I add one in BLOBI and error!

INSERT INTO BLOBTest

VALUES (,,â3â)

Msg 2714, Level 16, State 6, Line 1

There is already an object named 'BLOBTest' in the database.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near ','.

Old Pedant · June 16th, 2010, 03:54 PM

The error message is clear: The table BLOBtest already exists, so you can't create another table of that same name. Period.

Remove the old table before trying to create a new one of the same name.

sabra · June 19th, 2010, 03:45 AM

I will do it.