Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opportunistic or?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01083884
Message ID:
01083911
Views:
17
>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
Map
View

Click here to load this message in the networking platform