你可以对表的结构做如下修改
示例:
declare @tb1 table(id int identity(1,1),name char(10),par_id as [id])
insert into @tb1 (name) values ('a')
insert into @tb1 (name) values ('b')
insert into @tb1 (name) values ('c')
insert into @tb1 (name) values ('d')
select * from @tb1
/*
测试结果
id name par_id
----------- ---------- -----------
1 a 1
2 b 2
3 c 3
4 d 4
*/