Lesson 9. Creating Calculated Fields
In this lesson, you learn what calculated fields are, how to create them, and how to use aliases to refer to them from within your application.
Understanding Calculated Fields
Data stored within a database’s tables is often not available in the exact format needed by your applications. Here are some examples:
You need to display a field containing the name of a company along with the company’s location, but that information is stored in separated table columns.
City, state, and ZIP Code are stored in separate ...
Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
