Watch SQL Server Programming Part 9 - Table Variables in New Channel | Channify

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 - In SQL Server, Table Variables provide an alternative to Temporary Tables when working with temporary sets of data. This video teaches you how to declare table variables and insert records into them. You'll learn about the differences between table variables and temporary tables, including why one technique isn't always better than the other. Finally, you'll also hear about one of the common rumours surrounding table variables and why it's actually just a myth! You can view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s346/table-variables.htm The Microsoft Support article mentioned in the video can be found at: http://support.microsoft.com/kb/305977 You can download the script used to create the Movies database used in this video at: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip 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!