Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Finding procedures that use declared table variables RE: Finding procedures that use declared table variables
Phil Parkin
SSC Guru
Points: 247210
More actions
October 23, 2014 at 11:47 am
#1754446
ScottPletcher (10/23/2014)For temp tables, you must also consider:INTO #new_temp_tablerather than just CREATE.
ScottPletcher (10/23/2014)
INTO #new_temp_table
rather than just CREATE.
Good point! I try to stop people doing that in production code, but a few get through the net.