I need to use a variable in different SPs and functions (say, @GV_CCY_CD = 'USD'). How can I declare it globally, then use wherever it is required?
Asked
Active
Viewed 257 times
1
Iniyavan
- 61
- 1
- 5
-
1Is this helpful: https://stackoverflow.com/a/22372569/10549281? – Leon Yue Mar 10 '21 at 05:42
-
1This sounds like something that belongs in a configuration table. (which would be referenced by all of your SP's and functions) – Nick.Mc Mar 10 '21 at 05:57