Greetings,<BR><BR>I've used "WHERE 1=1" for a long time in dynamic where clauses in which every condition is optional, and lately I heard it suggested that this can cause full table scans by itself.
just some info for anyone else who's not a sql guru:<BR><BR>i did the following selection on a table:<BR><BR>SELECT * FROM Table WHERE myField <> 'active'<BR><BR>the values in that colum are a mix of ...
I've done an application where I run queries to a database. The first question I made worked very well... but then when I did another query in an other method I got ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback