--- use UNION ,for example:create table #U(id int , Fname varchar(100))
insert into Utable
select 1,'a'
union
select 2,'b'
union
select 3,'c'select * from #udrop table #u
insert into Utable
select 1,'a'
union
select 2,'b'
union
select 3,'c'select * from #udrop table #u
insert into #u
select 1,'a'
union
select 2,'b'
union
select 3,'c'select * from #udrop table #u
for i=字段1 to 字段3 do
Query.Sql.Append('insert into tab (字段I) Values()')
end
Query.ExeSql;