Query ID in SQL server

Question

1.00/5 (1 vote)

See more:

Hi Everyone..
I am querying data in Sql Server and i have face an error i mean a very awkward response.
i have 200 Records in my table and the Table id is in between 1-200. Now the problem is when i enter the Id = 332 it will also show me record even i don't have any id 332

What I have tried:

Here is my Query

Select MOSQUEID,NAME,CITY,POSTCODE,PHONE from tbl_mosque Where MOSQUEID=332

Posted 29-Apr-17 7:17am

Muhammd Aamir

Updated 29-Apr-17 7:41am

Add a Solution

Comments

Dave Kreskowiak 29-Apr-17 13:53pm

We can't see the rest of your code that is executing the query, nor the data in the table, so it's impossible to tell you what's going on here.

Open SQL Server Manager and verify that the ID number does NOT exist in the table.

Then run your code under the debugger, set a breakpoint at the start of your datbaase code that executes this query and single step through the code, examining the contents of variables to make sure they contain what you expect them to, and follow the logic.

Muhammd Aamir 29-Apr-17 13:59pm

Thankx Dave got the actual Issue :)

1 solution

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)

OriginalGriff · Accepted Answer · 2017-04-29T07:41:00

If this query:

SQL

Select MOSQUEID,NAME,CITY,POSTCODE,PHONE from tbl_mosque Where MOSQUEID=332

is returning any records, then you have one or more rows in your table which have a MosqueId of 332 - it will not invent such info!

So start by looking at the row(s) the query returns and see exactly what it is returning. Compare that to what is in the table (using SSMS to view the contents).
If the row doesn't exist, check your connection string and which table you are using.

It may be that you are using an IDENTITY column and assuming that having 200 entries implies that the IDENTITY values will always range from 1 to 200 - but SQL doesn't "reuse" values, so if you DELETE rows, and INSERT them again they will not get the same ID value.