2,598
社区成员




create table testp
(
id int identity(1,1) primary key,
tname varchar(100),
parentid int ,
)
insert into testp(tname,parentid) values('销售部',0)
insert into testp(tname,parentid) values('市场部',0)
insert into testp(tname,parentid) values('人事部',0)
insert into testp(tname,parentid) values('张三',1)
insert into testp(tname,parentid) values('张一',1)
insert into testp(tname,parentid) values('李四',2)
insert into testp(tname,parentid) values('王五',3)
insert into testp(tname,parentid) values('张力',3)
select * from testp