Feeds:
Posts
Comments

Posts Tagged ‘Temp Table’

SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged , on May 17, 2009 | 21 Comments »

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 [...]

Read Full Post »

SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on May 12, 2008 | 2 Comments »

Some questions never get old. One of them is temp table variable and temp table in SQL Server. I have previously wrote about this indepth here : SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are they really useful and efficient? [...]

Read Full Post »