SQL Server Programming Part 8 - Temporary Tables
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - There are many techniques in SQL Server for working with temporary data: this video deals with Temporary Tables (you know, the ones that begin with a #). You'll learn how to create and remove temporary tables, where they live during their short lifespans, how to extend their scope by using global temp tables, and how you can use temporary tables within stored procedures.
You can find a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s183/t...
You can download the script used to create the Movies database used in this video at:
https://www.wiseowl.co.uk/files/execi...
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Watch video SQL Server Programming Part 8 - Temporary Tables online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 06 February 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 88,636 once and liked it 674 people.