create table t(id int identity(1,1),a as id+100,b varchar(10)) insert into t(b) select 'aaa' --查看 select * from t