Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Creating a Table

Miguel Nunez
Miguel Nunez
3,266 Points
Posted by Miguel Nunez
Miguel Nunez
3,266 Points

What situations are temporary Tables are used in SQL?

I know what this is but why would I use it? In what situations? Iā€™m the type of person that needs logic and reasons why I should use things. Is this used as a method of a rough draft and quick sketching of a database table? Give me some feed back. Thank you.

1 Answer

Alexander Nikiforov
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points
Alexander Nikiforov
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points

The best thing I could've found is

http://www.codeproject.com/Articles/42553/Quick-Overview-Temporary-Tables-in-SQL-Server

Quoting from there

  • When we are doing large number of row manipulation in stored procedures.
  • This is useful to replace the cursor. We can store the result set data into a temp table, then we can manipulate the data from there.
  • When we are having a complex join operation.