62,074
社区成员
发帖
与我相关
我的任务
分享
declare @x int
set @x=0;
while (@x<100000)
begin
insert table ---这里是SQL语句
set @x=@x+1
end
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();