General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>I don't know if I should answer yes or no to these questions or if they are even asking the same thing or the oposite think (if I googled opportunistic I got a lot of hits about infection lol)
>
>Anywho. If the first condition is met the second is not checked.
>
>Proof:
>SELECT * FROM myTable WHERE 1 = 1 OR Id = 5
>gives the same result as
>SELECT * FROM myTable
>
>q.e.d.
>
>Einar
>
I know how I'd check this in VFP, but I don't know enough about SQL Server to verify anything. That being said.........
How does this query prove that the second condition is not checked? You'ld get the same result set one way or the other.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only