Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert data problems

Author  Topic 

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-08-03 : 17:00:25
I am trying to enter some rows in a table using the Query in Management Studio but get an error message 128. I also took out the quotes but same problem

INSERT INTO colors (Description, color)
VALUES ("Baked Goods", "Green")

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-03 : 17:07:54
change your double quotes to single quotes

Be One with the Optimizer
TG

EDIT:
btw, have you stayed in touch with Burt Ward?
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-08-04 : 11:50:05
The strange thing is that I entered this data but when I want to see the data entered, there is nothing there. I am using the modify option when I right click the table.
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-08-04 : 11:54:19
OK sorry I needed to open.
Go to Top of Page
   

- Advertisement -