string str="1,2,3,4,5,6,"; string[] value=str.Split(','); foreach(string id in value){ if(id!=""){
//执行SQL语句 id就是要插入的id值 } }
纯SQL实现: 1、将参数插入1个临时表 Create Table #Temp(F1 int) Insert into Temp values(1);Insert into Temp values(2)... 2、游标循环拼接SQL declare @txt varchar(max),@params int DECLARE MyAuthors CURSOR FOR SELECT F1 From Temp Open MyAuthors FETCH NEXT FROM MyAuthors Into @params WHILE @@FETCH_STATUS = 0 BEGIN set @txt=@txt+'insert into a1(pid,name) values('+@params+',@name);' FETCH NEXT FROM MyAuthors Into @params End CLOSE MyAuthors DEALLOCATE MyAuthors 3、执行sql exec (@txt)
string[] value=str.Split(',');
foreach(string id in value){
if(id!=""){
//执行SQL语句 id就是要插入的id值
} }
1、将参数插入1个临时表
Create Table #Temp(F1 int)
Insert into Temp values(1);Insert into Temp values(2)...
2、游标循环拼接SQL
declare @txt varchar(max),@params int
DECLARE MyAuthors CURSOR FOR SELECT F1 From Temp
Open MyAuthors
FETCH NEXT FROM MyAuthors Into @params
WHILE @@FETCH_STATUS = 0
BEGIN
set @txt=@txt+'insert into a1(pid,name) values('+@params+',@name);'
FETCH NEXT FROM MyAuthors Into @params
End
CLOSE MyAuthors
DEALLOCATE MyAuthors
3、执行sql
exec (@txt)
哦也 一边查一边帮忙的 。嘿嘿
1,2,3,4,5,6,