General information
Category:
Coding, syntax & commands
Sergey,
I didn't realize that.
Thanks again.
>David,
>
>>As far as the iciwhs.citemno+iciwhs.cwarehouse= sostrs.citemno+sostrs.cwarehouse is concerned, the compiler doesn't complain about it, and it runs. SQL Server seems to support the + operator in the statement. I haven't tested to make sure it returns the same results as doing it as:
>>iciwhs.citemno = sostrs.citemno AND iciwhs.cwarehouse= sostrs.cwarehouse
>>
>>but I'll check. Am I confused here? Shouldn't these statements be equivalent?
>
>They would produce the same result set but in the second case SQL Server could use indexes to optimize query.
Previous
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