SQL Server 2016 Part 7 - Computed Columns
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
Download files here: https://www.wiseowl.co.uk/videos/sql2...
https://www.wiseowl.co.uk - A computed column in a SQL Server table allows you to store an expression which calculates a new value based on the data in other columns of the same table. This video explains how to create computed columns and how to persist the result of the calculation so that it's stored in the table. You'll also learn a little about SQL Server's expression syntax, including how to use some of its built-in functions, the difference between deterministic and non-deterministic functions, how to use Case expressions to test conditions and how to concatenate strings. We'll do this by building a few example computed columns including constructing a full name from first and last name columns, calculating age in days using the DateDiff function and calculating age in years using DateDiff, DateAdd and a Case expression.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Auf dieser Seite können Sie das Online-Video SQL Server 2016 Part 7 - Computed Columns mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer WiseOwlTutorials 10 November 2016 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 31,636 Mal angesehen und es wurde von 324 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
