1.insert into [Table](field1,field2,field3) select 'f11','f21','f31' union all select 'f12','f22', 'f32' union all select 'f13','f23','f33' 构成如上的SQL语句2.同上3.从前在前
谢楼上,如果用sql 的 functioin来写怎么写呢
create function还不如直接用SQL语句。
foreach(TableInfo t in tableList) { TableInfoBLL.Add(t); } 数据库操作类 foreach(string s in fArray) { //insert } asc升序排列
insert into [table] select value10,value20,...valuen0 union all select value11,value21,...valuen1 union all ..... select value1n,value2n,...valuenn union all 或者在function中用pl/sql的循环语法或者insert into table1 (xx,xxx) select xx,xxx from table2明白?
select 'f11','f21','f31' union all
select 'f12','f22', 'f32' union all
select 'f13','f23','f33'
构成如上的SQL语句2.同上3.从前在前
{
TableInfoBLL.Add(t);
}
数据库操作类
foreach(string s in fArray)
{
//insert
}
asc升序排列
select value10,value20,...valuen0 union all
select value11,value21,...valuen1 union all
.....
select value1n,value2n,...valuenn union all
或者在function中用pl/sql的循环语法或者insert into table1 (xx,xxx) select xx,xxx from table2明白?