个人意见,既然B,C,D都是计算的结果,设置一个字段A就够了.再写个类似这样的视图,方便以后使用:
create view 视图名
as
select A
,B=A*1.3
,C=60+datediff(year,'2004-1-1',getdate())*8
,D=A+A*1.3+60+datediff(year,'2004-1-1',getdate())*8
from 表
create view 视图名
as
select A
,B=A*1.3
,C=60+datediff(year,'2004-1-1',getdate())*8
,D=A+A*1.3+60+datediff(year,'2004-1-1',getdate())*8
from 表
A int,
B as A*1.3,
C as 60+datediff(year,'2004-1-1',getdate())*8,
D as A+A*1.3+60+datediff(year,'2004-1-1',getdate())*8)