高分求助：向数据库关联表中批量插入数据？
向一个数据库中批量插入数据，表如下：
company(id,name,address)
department(id,companyID,name,power)
person(id,departMentID,name,sex)
该怎么办的好，请高手指点。解决给分？？？？？？？？？
[解决办法]
循环插入就行了啊，主要把关联字段弄对
[解决办法]
insert into company(id,name,address) values(0,"","")
insert into department(id,companyID,name,power) values(0,@@identity,"","")
insert into person(id,departMentID,name,sex) values(0,@@identity,"","")
或
declare @bh int
insert into company(id,name,address) values(0,"","")
select @bh=max(id) from company
insert into department(id,companyID,name,power) values(0,@bh,"","")
select @bh=max(id) from department
insert into person(id,departMentID,name,sex) values(0,@bh,"","")
[解决办法]
同意2楼的
[解决办法]
sorry!第一次我以为没有成功,所以又发了一次!
[解决办法]
