Re: IN Clause - Stuck on an easy query :-(
From: nib (nib_at_nibsworld.com)
Date: 09/01/04
- Next message: rgn: "Hexadecimal to Decimal Conversion"
- Previous message: alekas: "RE: Check Constraint"
- In reply to: Joe Celko: "Re: IN Clause - Stuck on an easy query :-("
- Next in thread: Steve Kass: "Re: IN Clause - Stuck on an easy query :-("
- Messages sorted by: [ date ] [ thread ]
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
- Next message: rgn: "Hexadecimal to Decimal Conversion"
- Previous message: alekas: "RE: Check Constraint"
- In reply to: Joe Celko: "Re: IN Clause - Stuck on an easy query :-("
- Next in thread: Steve Kass: "Re: IN Clause - Stuck on an easy query :-("
- Messages sorted by: [ date ] [ thread ]