Just created a new tabel/database. The table is
Category
Cat_id(char(2)not null)
CatName(char(25),null)

Inset statement:


Error message:
Msg 128, Level 15, State 1, Line 2
The name "Dance-Ballet" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

What am I missing? And how do I fix ASAP!
Thanks for the help.

Try INSERT INTO Category (Cat_id, CatName) VALUES ('01', 'Dance-Ballet')

Are you trying to create an identity column for Cat_id? If so, you would never have to insert a value since SQL will create a new identity for every insertion.

Just make Cat_id into an identity column.

Hope this helps.

Richard

how do I make this an identity column in SQL Manager? I understand that it is not necessary to insert a value in the Cat_id column. I tried the code
(NSERTINTO Category (Cat_id, CatName)VALUES('01','Dance-Ballet');)
and get the error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Category'.


I can't find a way to upload a screen print...

Any other ideas?
Thanks

The syntax is INSERT [space] INTO

You also need spaces on either side of VALUES

Try this:

SELECT * FROM Category

Let me know what results you get.

You need to modify the table. What version of SQL are you using?

resluts from " Select * from Category"

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Category'.

Am using SQLEXPRESS (SQL Server 9.0.1399...)

Looks like you don't have any table named Category in that database.

Not sure why, since you say you created the table.

Did you try looking at the DB with SQL Server Management Studio? There should be a free Express edition you can use.

Lets close this, I have had to move to a different method, since this was not working...too much time for something that should be simple.
Thanks for all the help.

You have another schema than dbo?