SQL Server 2016 Part 7 - Computed Columns

Pubblicato il: 10 novembre 2016
sul canale di: WiseOwlTutorials

31,636

324

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

In questa pagina del sito puoi guardare il video online SQL Server 2016 Part 7 - Computed Columns della durata di ore minuti seconda in buona qualità , che l'utente ha caricato WiseOwlTutorials 10 novembre 2016, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 31,636 volte e gli è piaciuto 324 spettatori. Buona visione!