SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable | Journey to SQL Authority with Pinal Dave

#TempTable and @TempVariable are different things with different scope. Their purpose is different but highly overlapping. TempTables are originated for the storage and & storage & manipulation of temporal data. TempVariables are originated (SQL Server 2000 and onwards only) for returning date-sets from table-valued functions. Common properties of #TempTable and @TempVariable They are instantiated in… Continue Reading...

Source: SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable | Journey to SQL Authority with Pinal Dave