Can someone explain to me the difference between
Declare @Season Table()
Create Table #Season
I realize one creates a temp table and the other creates a variable of type table, in the end they basically do the same thing, are there guidelines as to which one should be used over the other, memory concerns, locking, etc. Any input you have is appreciated.