A
A
AcidBat2015-11-28 18:44:51
SQL
AcidBat, 2015-11-28 18:44:51

SQL doesn't want to accept any numbers other than one. What is the problem?

Suppose the server (ASP.NET) has a database file in mdf format. It has a table with some fields. One of these fields (let's say ssf) contains only integer values. There are 3 records in the database - two with the ssf parameter equal to 1, and the third one with the ssf parameter equal to 2.
When selecting records by the ssf parameter with a value of 1, the database adequately returns two records that satisfy the condition (ssf = 1), but when selecting records for the ssf parameter with a value of 2, the base always returns null. Even if we replace the digit 2 with any other than one, and perform a selection according to the parameter ssf = 3, then the selection also does not occur. The query structure is the same with a difference of 1 digit.
What could be the problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Skorzhinsky, 2015-11-28
@AndyKorg

Obviously in the request text - run profiler and look at the request text.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question