Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > BOOK: Beginning SQL
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning SQL
This is the forum to discuss the Wrox book Beginning SQL by Paul Wilton, John Colby; ISBN: 9780764577321
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning SQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 16th, 2010, 11:44 AM
Authorized User
Points: 359, Level: 6
Points: 359, Level: 6 Points: 359, Level: 6 Points: 359, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2006
Location: Belgrade, Serbia, Yugoslavia.
Posts: 73
Thanks: 11
Thanked 1 Time in 1 Post
Talking error in code!

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 ','.
Reply With Quote
  #2 (permalink)  
Old June 16th, 2010, 03:54 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,652
Thanks: 3
Thanked 141 Times in 140 Posts
Default

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.
Reply With Quote
The Following User Says Thank You to Old Pedant For This Useful Post:
sabra (June 19th, 2010)
  #3 (permalink)  
Old June 19th, 2010, 03:45 AM
Authorized User
Points: 359, Level: 6
Points: 359, Level: 6 Points: 359, Level: 6 Points: 359, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2006
Location: Belgrade, Serbia, Yugoslavia.
Posts: 73
Thanks: 11
Thanked 1 Time in 1 Post
Post Old Pedant!

I will do it.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Code Error rhapsidee VB.NET 2002/2003 Basics 1 May 27th, 2008 07:04 AM
Error in Code NadAf BOOK: Ivor Horton's Beginning Visual C++ 2005 0 February 18th, 2008 10:16 PM
Code error reverand Excel VBA 1 November 15th, 2006 01:08 AM
Code error??? emyr BOOK: Beginning Java 2 1 October 31st, 2006 04:47 PM
Error displayed with error trap code stoneman Access 4 February 28th, 2004 01:53 PM



All times are GMT -4. The time now is 10:12 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.