Re: Anything like Constants in SQL Server?

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

From: David Browne (meat_at_hotmail.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 11:02:00 -0500

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%238F65%23vTEHA.1508@TK2MSFTNGP11.phx.gbl...
> I use a constants or properties table. There is no such thing as a
constant
> or global in SQL Server...
>
> --

Just beware that joining in a constants table complicates your query plans
and interferes with index selectivity analysis. For cheap queries, it's no
big deal, but in an expensive query it can be fatal.

David