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
[ Ссылка ] - If you have a calculation that you frequently use in SQL queries you're probably bored of writing out the same code time after time. Why not try creating a user-defined function to save you the hassle! This video teaches you how to define your own custom functions, including how to use input parameters, how to alter a function after you've created it, and even how to use fancy programming techniques such as variables and IF statements to help structure complex sequences of calculations.
A written version of this tutorial with more function examples can be found here:
[ Ссылка ]
You can download the script to create the Movies database used in this video at the following link:
[ Ссылка ]
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!
![](https://i.ytimg.com/vi/6BslHItOTjU/maxresdefault.jpg)