insert into 表 select .......... ;insert into 表 select ........
但可放在一起执行.
------解决方案--------------------
C# code
Sqlconnection connection=new SqlConnection();
string sql="INSERT Biao SELECT xx,xx,xx,xx,xx
UNION ALL SELECT xx,xx,xx,xx,xx
UNION ALL SELECT xx,xx,xx,xx,xx
UNION ALL SELECT xx,xx,xx,xx,xx";
SqlComand command=new SqlCommand(sql,connection);
connection.Open();
int count=command.ExecuteNonQuery();
connection.Close();
------解决方案--------------------
declare @x int
set @x=0;
while (@x<100000)
begin
insert table ---这里是SQL语句
set @x=@x+1
end
------解决方案-------------------- insert into talbe1 select * from table2
------解决方案-------------------- [color=#FFFFFF][/color]