Reputation: 1
for example if I declared one variable like - Declare @Test Int, where the SQL server store this variable?
Upvotes: 0
Views: 410
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