Create a computed column : Column « Table « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Table
3. Column

3>
4> SET QUOTED_IDENTIFIER ON
5> GO
1>
2>
3> CREATE TABLE employee
4> (ID int NOT NULL,
5> total int NOT NULL,
6> count int NOT NULL,
7> AvgSharesPerShareholder AS (total/count) PERSISTED);
8>
9> select * from employee;
10> GO
ID          total       count       AvgSharesPerShareholder
----------- ----------- ----------- -----------------------

(0 rows affected)
1>
2> drop table employee;
3> GO
1>
2> SET QUOTED_IDENTIFIER OFF
3> GO
1>