如何在SQL Server2005中创建选择查询 [英] how to create select query in 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>

这篇关于如何在SQL Server2005中创建选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！