保留旧数据:EXEC sp_rename 'MyTable.OldCol', 'RenamedOldCol', 'COLUMN'; 添加计算列ALTER TABLE MyTable ADD ComputedCol AS (some expression); 然后,当你感到满意时ALTER TABLE MyTable DROP COLUMN RenamedOldCol;