MSBI Learner
MSBI Learner

Reputation: 1

Where does the variables store in the SQL server?

for example if I declared one variable like - Declare @Test Int, where the SQL server store this variable?

Upvotes: 0

Views: 410

Answers (1)

Koby Douek
Koby Douek

Reputation: 16693

SQL Variables are not stored anywhere on the server. They are session variables that are omitted once the session is closed. You can only use a SQL variable in the same session you declared it, within the block in which it is declared.

Upvotes: 1

Related Questions