我们可以在一个事务中实现,首先删除计算字段,然后修改字段类型,最后将计算字段加回原来的表:
BEGIN
TRANSACTION
GO
alter table t9 drop column record_name
go
alter table t9
alter column
name varchar ( 10 ) not null
go
alter table t9
add
record_name as name
go
COMMIT
GO
alter table t9 drop column record_name
go
alter table t9
alter column
name varchar ( 10 ) not null
go
alter table t9
add
record_name as name
go
COMMIT
