Using generated columns 

A generated column allows you to store data in a column based on an expression. Generated columns can be useful when you want to store something in a table based on other columns. For example, if you wanted to have the batting average stored, you would need to divide other fields in the batting table to do this. Generated columns can be helpful instead of having to calculate a value every time you execute a query. With a generated column, you will just put the generated column name in the query instead of having to calculate on the fly. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.222.196.175