-->用计算列create table #(col1 int identity, col2 as col1+1)
insert # default values
insert # default values
insert # default valuesselect * from #/*
col1 col2
----------- -----------
1 2
2 3
3 4
*/drop table #
insert # default values
insert # default values
insert # default valuesselect * from #/*
col1 col2
----------- -----------
1 2
2 3
3 4
*/drop table #
http://topic.csdn.net/u/20080227/14/8bce0844-bd15-42f0-9cda-a343d5d6601b.html
--用公式create table tab(col1 int identity, col2 as col1+1)