第1个回答 2010-02-01
-- 加个括号就可以了,和一般算术式一样
create table test (
A int not null,
B int not null,
C as ([A]+[B]) ,
D int not null,
E as (([A]+[B])*[D])
)本回答被提问者采纳
第2个回答 2010-02-01
这样就行:
CREATE TABLE [表名] (
[a] int NULL,
[b] int NULL,
[c] AS a+b,
[d] int NULL,
[e] AS (a+b)*d
)
GO
第4个回答 2010-02-01
select a,b,a+b as c ,(a-b) as d ,--你没说d,我就用a-b代了
(a+b)*(a-b) as e