If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link [ Ссылка ] to make a donation. Thanks for watching!

By Andrew Gould

[ Ссылка ] - 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:
[ Ссылка ]

The Microsoft Support article mentioned in the video can be found at:
[ Ссылка ]

You can download the script used to create the Movies database used in this video at:
[ Ссылка ]

You can see the range of resources and courses we offer in SQL Server here:
[ Ссылка ]

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!

свернуть