Home / Questions / 329136
Accepted
Diego
Asked: 2020-02-14 06:47:33 +0800 CST 2020-02-14 06:47:33 +0800 CST

Global constants in SQL

  • 772

Is there a way to share constants / variables in the same DB between several stored procedures in SQL SERVER?

I don't want to use temporary tables, or functions, or stored procedures.

I have seen that something can be done with the Context, but the idea is to be able to share constants between procedures, defined only once.

sql

1 Answers

  1. Best Answer

    I was investigating and the way I saw today to be able to generate "constants", since they don't exist as such, is to generate a read-only table in which to consult them.

    • 0