如何在SQL Server2005中创建选择查询
问题描述：
当我在下面的查询中触发时，然后显示错误消息
给出简单的选择查询.....
when i fire below query ,then display error message
give simple select query .....
Select no, name
from tb1
where name='rahul' ;
消息208，第16级，状态1，第3行
无效的对象名称"tb1".
请给我解决方案...
Msg 208, Level 16, State 1, Line 3
Invalid object name ''tb1''.
pls give me solution...
答
^ ]扫一眼，这将对您有帮助.
Select Query[^] just have a glance this will help you.
您提到的无效对象名称" tb1""错误只是表示数据库中没有表tb1. .请确保您已经创建了表tb1.
希望这会有所帮助.
一切顺利.
The error that you have mentioned "Invalid object name ''tb1''" simply says that the table tb1 is not there in the database. Please make sure that you have table tb1 already created.
Hope this helps.
All the best.
您的错误表示表在当前架构中不存在
验证连接的架构是否正确.
例如:
Your Error Means that table does not exist in the Current Schema
Verify your schema , that is connected is correct or not.
example :
Select no, name
from <schema>.dbo.tb1
where name='rahul' ;</schema>