by Oz Ben Elieze » Sun, 29 Oct 2000 02:24:06
I'm using MS-SQL Server 2000.
My question is this -
When using an IF clause in a stored procedure - suppose it has several ANDs,
like:
unncessarily? I need to write an IF clause with about 100 of those
comparisons, and I need it to evaluate as quickly as possible. If the answer
to the previous question is yes, what would you suggest I do?
Thanks,
Oz
by Hemo » Wed, 01 Nov 2000 02:31:26
> I'm using MS-SQL Server 2000.
> My question is this -
> When using an IF clause in a stored procedure - suppose it has several
ANDs,
> like:
> unncessarily? I need to write an IF clause with about 100 of those
> comparisons, and I need it to evaluate as quickly as possible. If the
answer
> to the previous question is yes, what would you suggest I do?
> Thanks,
> Oz
1. MS-SQL Server, INTERNALS, IF clause, -=addition=-
Sorry for sending another message in the issue, but I would like to enhance
my question.
My IF clause actually looks like this:
....
the answer to the previous question is yes, what would you suggest I do to
do those comparisons and evaluations as quickly as possible?
Thanks a lot !
Oz
2. Web Forms Developer 2000 (Oracle doesn't tell all) it works!
3. SQL Server INTERNALS: IF clause
4. US-MD,VA,DC ORACLE FINANCIALS FUNCTIONAL
5. (for MS) bug: No where clause in view causes error 8630 - Internal Query Processor Error
6. Share modem, ISDN and cable modem 12184
7. GA-Alpharetta-110503--MS SQL Server-DBA Skills-Database Administrator (DBA)-MS SQL Server
8. 29346-OR-Greater Eugene Area-Software Development-Architecture Design-SYBASE-ORA
9. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000
10. SQL Join clause to emulate an SQL (where not in) clause
11. Ms-SQL Internals
12. SQL Server bug 2 - Internal server error