Today I have uploaded SQL Server Quickie #32 to YouTube. This time I’m talking about the difference between Temp Tables and Table Variables in SQL Server.
I think when you execute the stored procedure multiple times, you’ll see there is only a recompilation the first time.
The second time nothing will be recompiled.