建表

/*----------------------------------------------------------

  2009-7-2   本地 建表 

----------------------------------------------------------*/
use Test
go

create table Family
(
memberid int primary key,
membername varchar(10),
parentmemberid int
)
go

delete from Family
go

insert into Family(memberid,membername,parentmemberid)   values(0,'ooo',-1)
insert into Family(memberid,membername,parentmemberid)   values(1,'aaa',0)
insert into Family(memberid,membername,parentmemberid)   values(2,'bbb',0)
insert into Family(memberid,membername,parentmemberid)   values(3,'ccc',1)
insert into Family(memberid,membername,parentmemberid)   values(4,'ddd',1)
insert into Family(memberid,membername,parentmemberid)   values(5,'eee',2)
insert into Family(memberid,membername,parentmemberid)   values(6,'fff',2)
insert into Family(memberid,membername,parentmemberid)   values(7,'ggg',3)
insert into Family(memberid,membername,parentmemberid)   values(8,'hhh',3)
insert into Family(memberid,membername,parentmemberid)   values(9,'iii',4)
insert into Family(memberid,membername,parentmemberid)   values(10,'jjj',4)
go

select * from Family
go