Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Defining constants
Message
De
11/10/2001 22:16:48
 
 
À
11/10/2001 12:08:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00566957
Message ID:
00567383
Vues:
13
>I'm not sure how well that would work. Values in the table need to be returned in a result or result set at the beginning of each procedure.

Sure it would work.

CREATE TABLE constants (
OneItemDisc float,
TenItemDisc float)

Inside a stored procedure, you could do something like this:

DECLARE @OneItemDisc float, @TenItemDisc float

SELECT
@OneItemDisc = OneItemDisc,
@TenItemDisc = TenItemDisc
FROM
constants

...

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform