how to create select query in sql server2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

when i fire below query ,then display error message
give simple select query .....

SQL

Select no, name
from tb1
where name='rahul' ;

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

pls give me solution...

Posted 9-Feb-11 20:31pm

somil030

Updated 9-Feb-11 20:47pm

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ramalinga Koushik · Answer 1 · 2011-02-09T20:34:00

Solution 1

Select Query[^] just have a glance this will help you.

Posted 9-Feb-11 20:34pm

Ramalinga Koushik

Comments

somil030 10-Feb-11 2:53am

By using suggest query inside link error msg display,table emp1 already in my database.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'emp1'.

Pravin Patil, Mumbai · Answer 2 · 2011-02-09T20:43:00

Solution 2

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.

Posted 9-Feb-11 20:43pm

Pravin Patil, Mumbai

Comments

somil030 10-Feb-11 2:46am

table tb1 already there pls suggest simple select query in sql2005

Rajesh Anuhya · Answer 3 · 2011-02-09T20:50:00

Solution 3

Your Error Means that table does not exist in the Current Schema
Verify your schema , that is connected is correct or not.

example :

SQL

Select no, name
from <schema>.dbo.tb1
where name='rahul' ;</schema>

Posted 9-Feb-11 20:50pm

Rajesh Anuhya

Comments

somil030 10-Feb-11 2:58am

how do i verify schema?

m@dhu · Answer 4 · 2011-02-09T21:13:00

Solution 4

Just try the following.

Creates a new table into your database

SQL

create table testTable
(testName varchar(50),testAddress varchar(50))

Inserts values

SQL

insert into testtable(testname,testaddress) values('Myname','Address')

Gets the values from column testname

select testname from testtable

Posted 9-Feb-11 21:13pm

m@dhu

Comments

somil030 10-Feb-11 4:09am

using given example teble created successfully but insert query does not work and display following msg ...
Msg 208, Level 16, State 1, Line 1
Invalid object name 'testTable'.

m@dhu 10-Feb-11 4:18am

I think you are using different database in which the table isn't present so the error comes Now check 'YourDataBaseName' should be same in which you created the table.
USE [YourDataBaseName]
GO
insert into testtable(testname,testaddress) values('Myname','Address')