--删掉重加吧 Alter table Table1 drop column ColumnCAlter table Table1 add ColumnC as ColumnA+ColumnB
Alter table Table1 drop column ColumnCAlter table Table1 add ColumnC as ColumnA*ColumnB
create table #t(a int , b int ,c as a+b)insert into #t(a,b) values(10,20) insert into #t(a,b) values(30,50)select * from #talter table #t drop column c --删掉原来的计算列select * from #talter table #t add c as a*b --添加计算列c=a*bselect * from #tdrop table #t
用SQL添加计算列时不能带有column系统保留字必须如下:alter table #t add c as a*b
Create table aaa (id int, value int, Ps as id+value)insert into aaa select 1,2ALTER TABLE aaa drop column ps ALTER TABLE aaa ADD ps as id*valueselect * from aaa--删除测试用表
Alter table Table1 drop column ColumnCAlter table Table1 add ColumnC as ColumnA+ColumnB
insert into #t(a,b) values(30,50)select * from #talter table #t drop column c --删掉原来的计算列select * from #talter table #t add c as a*b --添加计算列c=a*bselect * from #tdrop table #t
Create table aaa
(id int,
value int,
Ps as id+value)insert into aaa
select 1,2ALTER TABLE aaa
drop column ps ALTER TABLE aaa
ADD ps as id*valueselect * from aaa--删除测试用表
其它三位的做法可行,我也是这样做的,做本来是想求一条直接修改计算列定义的语句,
看来MS SQL Server是不是不持呀,谢谢各位的热心