ASP+MSSQL批量添加进数据库怎么写

textarea=Request("textarea")'获取输入框的内容

If inStr(textarea,chr(13)&chr(10))>0 then'判断是否有换行符

textarea=Split(textarea,chr(13)&chr(10), -1, 1)'用换行符把内容分割成数组

For i=0 to UBound(textarea)'循环数组

Conn.Execute "Insert Into [表名] (username,shuju,password) Values ('username值','"&textarea(i)&"','password值')" '写入数据库

Next

End If

%>

create function f_id ()

returns int

as

begin

declare @id int

select @id=isnull(max(id),0)+1 from mywork

return @id

end

insert into mywork (id,name,date) values (dbo.f_id(),'张三','2009-10-10')

以上，希望对你有所帮助