General information
Forum:
Microsoft SQL Server
>>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
Oh, I thought he might be trying to get it to work like an Automatic variable. like @@Rowcount. The only reason I say it, is because I once wished I could create some constants globally to just access as needed in any procedure. Is there a way to do it.
Thanks
Respectfully (as you guys answer most of my questions too!)
Jeff
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only