Is there any option to set global variable in SQL?

Question

I need to use some values (table values Ex: StudentId) in many Stored procedures. So I need to query that value in every stored procedure. In MVC I am able to store that value in WebConfig. But in SQL how can I do that?

Is there any option to store that value globally to refer it in a Stored procedure?

http://www.codeproject.com/Articles/39131/Global-Variables-in-SQL-Server — mohan111, Apr 10 '15 at 16:57

score 1 · Answer 1 · answered Apr 10 '15 at 16:56

If you need configuration values in a database, you can just create a new table and call it something like ConfigurationParameters, then query whenever you need a value from it.

If you can't do that, then create a StoredProcedure or Function that always returns the value you need.

score 0 · Answer 2 · edited May 23 '17 at 11:51

0

It does not look like you can directly make global variables SQL server.

I found another question that is very similar to yours with useful information.

how to declare global variable in SQL Server..?

Hope this helps.

edited May 23 '17 at 11:51

Community

1
1

answered Apr 10 '15 at 17:19

Richard Hall

1
3

Is there any option to set global variable in SQL?

2 Answers2