• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

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?
0
mtnbuzz
Asked:
mtnbuzz
  • 2
1 Solution
 
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
 
BillAn1Commented:
Then you should try INSERT INTO  [dbo].[company$item] ([No.] ) VALUES (1)
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now