T-SQL error Invalid object name 'dbo.company$Item.No.'.

I can see this table from QA & EM?  Why will it not allow me to INSERT INTO?
mtnbuzzAsked:
Who is Participating?
 
BillAn1Connect With a Mentor Commented:
Then you should try INSERT INTO  [dbo].[company$item] ([No.] ) VALUES (1)
0
 
BillAn1Commented:
is the table name company$item.No. ?
If it is, then enclose it in brackets, e.g. select * from [dbo].[company$item.No.] the dot in the name is misinterpreted
0
 
mtnbuzzAuthor Commented:
The exact table name is dbo.company$item  and the column is No.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.