Utilizing ms sql temporary table
There are two types of temporary table in ms sql : local and global temporary table. You can read it further about that here and here.
For me, the best thing I found about this is that, this table will be created in tempdb table and it is only for temporary.It will be gone once you close your session. 
I found out it very useful if I want to do patching or debugging with my data and many more reason for me to use it.
Below are few simple way how you can play around with temp table.
Well, of course you can do a lot of thing more than this. For example:
This is just to show how we can utilize the usage of temporary table.
![[Ask]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/ask.png)
![[Bloglines]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/bloglines.png)
![[del.icio.us]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/digg.png)
![[Furl]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/furl.png)
![[StumbleUpon]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/technorati.png)
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
