Temporary tables in SQL Server Part 34

In this video we will learn about
1. What are temporary tables
2. The 2 different types of temporary tables -- Local Temporary Tables and Global Temporary tables
3. Difference between local and global temp tables

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[sudheerswarna]

Google'd across many websites, but none of them are clear than your tutorials... Best in Best

[Csharp-video-tutorialsBlogspot]

Hi, thank you very much taking time to answer this question. As, I am receiving lot of questions everyday from our youtube users, I am finding it extremely difficult to answer all the questions in time. With your help I am confident, we will be able to answer most questions in time. Appreciate your time and effort. God bless you.

[Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[sujithsai]

Most underrated sql course in youtube why these videos have less likes. i am learning easy as a beginner thankyou so much sir.

[eshwarmmm]

Bro, You are genius, Thank you so much, I read many articles about this, but i did not get clear idea. Now i got.

[nachiket]

I wish ALL the tutorials on YouTube were this comprehensive and yet simple to understand. Excellent work. Thanks for this.

[KuriaNdungu]

Very well explained. Love your videos. you are blessed with the ability to explain in a way that is easy to understand. Thank you!

[TirumalaSrinivasudu]

Thanks for the video.. It's pretty clear explanation.. Keep posting more videos on sql...

[rakeshpandey]

Still there are no such details I found in another channels..you are the best @kudvenkat sir 💐. Thankyou so much sir

[bsabhiram]

Simple way to illustrate the concepts. Thanks for sharing this playlist on SQL. I find videos far useful than reading books.

[zainulabideen]

Great Teacher Sir Venkat. Amazing Methodology with great knowldge

[SathishKumar-gser]

The way of explanation is too good, i would like to watch all your SQL videos and learn SQL...Thanks a ton sir!!!

[krismaly]

AWESOME. Concept explained crystal clear. I would recommend others to watch.
Thanks a bunch 

[krismaly]

I enjoyed watching this video. I suggest all developers to watch. Conceptually explained very clear. Also at the end mentioned interview questions on the topic.

Dear Venkat I think after every video you make please include probable interview questions if possible that makes very good sense.

Thanks a bunch

[venkatarao]

Excellent And Good videos yet simple Learning to understanding.Thanks for this.

[Nehasingh-epmf]

This video helped me a lot....Very informative...

[sajidhameed]

Try to correct you sir well explained but in case of global temp table if you create a table in one connection and that connection is closed it will dropped automatically and you can't select query in second open connection.

[phpmysql]

You are clear and easy to understand thank you sir.

[AJSAMUEL]

Hi Venkat, thank you so much for making these videos and sharing your knowledge. You are doing an awesome job. God Bless you too :)

[surendra_tarai]

It seems very easy, i like your all videos. but It will better if you can keep less duration of video.