SQL Server Programming Part 8 - Temporary Tables

[@pritamvarsani2328]

These videos are brilliant. I use SQL everyday, but just watching your videos over the last few days has given me incredible amount of new tools to use at work. Thank you.

[@Bakkasura]

This video is done very well, I'm in India learning SQL and my instructor here likes to skip over critical details so your videos do an excellent job filling in the gaps and ensuring that I retain the concepts that I learn. Thank you good sir!

[@rajkumarrajan8059]

Your videos helping me learning SQL .

[@WiseOwlTutorials]

Happy to hear the videos are helping you, thanks for watching!

[@BRelding92]

Hi Andy, I'm currently revising for my Microsoft 70-461/462/463 exams and your videos are easily the most understandable.

[@Emiliobolton]

Thanks for putting out these great informational videos. Priceless information for someone looking to expand their knowledge for workplace application.

[@VenkatteshRao]

Thanks very much for all your videos, I really love the way you structured your examples in the videos and the videos themselves, to top it all off the videos are only 15-20 minutes long while fully covering the concept. Great job, well done.

[@krismaly]

Your videos are awesome. I enjoyed watching and learning. All freshmen developers should watch your videos. Thanks

[@kalyandaddanala6114]

That's a great comparison on temporary tables. Thank You for sharing this.

[@mistery4437]

You sound wiser than you claim. Cheers!

[@Haritharameshvandanapu.]

thank you. you are a very good teacher.

[@WiseOwlTutorials]

Thank you very much for watching and for taking the time to comment!

[@Africanschild]

Hello, im in half way of watching your Tutorial. Mr. You just earned new sub. I want to thank You very very much :D

[@Anthony-my8gw]

I live in the US so I can't attend one of your seminars. If your company created blocks of videos and charged I would be more than happy to buy them. SQL Server, SSRS, SSIS. You're one of my favorite teachers. Having seminars might be more profitable, but videos expose you to a larger audience and I'd be happy to pay you for in depth tutorials.

[@olegsuslov7593]

Excellent lesson. Waiting for common table expression.

[@danielmdev]

Thanks for sharing your knowledge :D

[@WiseOwlTutorials]

You're welcome Daniel! Thanks for watching and taking the time to leave a comment!

[@GlicerioCatolico]

sir how to use that stored procedure with temp table sql in vb 2010? I want to click a button and it will create a temporary table...help pls! thank you!

[@fadwa2413]

Thank You SO MUCH

[@WiseOwlTutorials]

You're very welcome!

[@aboyapart]

Lets say that I want to create a table T with two columns A and B. Lets say that I want to fill column A from one specific column in a table of my data base and I want to fill B with another column in another table of my data base. What would happen if the sizes of those columns differ? Let say that column A will have 7 entries and column B 10 entries. Then would my table T have two columns with 10 entires overall, where column A have NULL on the last 3 entries? or will this result in an error? In order to work do I have to create the tables with NULL ?

[@BijouBakson]

For the second method: The INSERT INTO SELECT does create the table for you. So I wander: Is there any need to create the table first or this is just a limitation of an older version of SQL Server? Thanks

[@WiseOwlTutorials]

Hi, that's not correct. You can check this by trying to drop the destination table first. The following will fail: drop table if exists #DestinationTable go insert into #DestinationTable select * from SourceTable You can select into to create the destination table if you like: drop table if exists #DestinationTable go select * into #DestinationTable from SourceTable

[@BijouBakson]

@@WiseOwlTutorials thank you.

[@WiseOwlTutorials]

@@BijouBakson You're welcome!

[@BijouBakson]

@@WiseOwlTutorials I came back on this again as I wasn't sure. It seems like the INSERT INTO SELECT statement has an exception for temporary tables. Perhaps that is due to the limitation that comes with it being live records only. i.e, existing only for as long as the connection is open. Just a note. Thank you.

[@BijouBakson]

@@WiseOwlTutorials Thank you for that answer. What I actually meant was using the INSERT INTO SELECT clause something as follows: INSERT INTO #TempFilms( Title, ReleaseDate ) SELECT( FilmName, FilmReleaseDate ) FROM TblFilm ... This works on normal table; it should work on temporary table, shouldn't it? Another question, regarding stored procedure. I suspect it should work because the stored procedure would be in memory; but just to make sure I'm right - The stored procedure would still execute if you closed the both SP connection, wouldn't they?

[@arghyanandy6469]

You are the best teacher, you know that?

[@nileshsarkar2593]

He put lamborghini as a interesting model which we can afford, nice one

[@JosueLopezXIX]

Thank you, indeed it is a good understanding how to create, insert to a temp-table.

[@JosueLopezXIX]

No problem, i'll definitely be watching more videos and advertising them more often ;)

[@pbsviewer13]

appreciate the lesson. thanx.

[@Wisdom909]

Thank you so much.!!

[@dayobabatunde8723]

Thanks for your wonderful presentations!

[@khanst3r]

thanks!

[@BRelding92]

you are awesome.

[@MerghaniMekki]

Very helpful thanks :D

[@rajeshjayaram53]

Thanks for your clear sounds ...!!!!

[@vh8000]

👍👍👍

[@Rational108]

What a beautiful explanation..Only @WiseOwl series is permanent in my phone rest all are Temporary..

[@GlicerioCatolico]

thank you sir ^^

[@hirenthanki2932]

Very expensive taste in cars I must say.

[@ItsWithinYou]

Very well explained! Thank you for sharing!

[@WiseOwlTutorials]

Thanks Rajiv, thank you for watching!