Re: IN Clause - Stuck on an easy query :-(

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: nib (nib_at_nibsworld.com)
Date: 09/01/04


Date: Tue, 31 Aug 2004 23:30:26 -0500


Joe Celko wrote:
>
> Parameterized stored procedures are also a bad idea. They will not port
> (which is what MS wants as part of its fight against Open Source). Most
> of the validations can be easily done with CHECK(), DEFAULT and
> REFERENCES. The CHECK() constraints and REFERENCES also provide extra
> predicates for the optimizer.
>

What do you mean by "parameterized stored procedures"?

Zach