Thursday, October 31, 2013

Local temporary table vs table variable - SQL Server 2008 R2/2012

Hi,


looking inside an old stored procedure I've seen the definition of a local temporary table as SELECT ... INTO #tmptable.


In this case, and more in general, could it be better to use a table variable, also the performance of the stored procedure?


Thanks


No comments:

Post a Comment