Pages

Saturday, September 7, 2013

SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table | Journey to SQL Authority with Pinal Dave

I have received following questions numerous times: "How to check existence of Temp Table in SQL Server Database?" "How to drop Temp Table from TempDB?" "When I try to drop Temp Table I get following error. Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. How… Continue Reading...

Source: SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table | Journey to SQL Authority with Pinal Dave