asp循环插入同一个数据

如何把字段title同时循环插入200条?
2025-03-23 03:09:24
推荐回答(2个)
回答1:

for i=1 to 200
conn.execute("insert into [表名] (title) values ('" & i & "')")

next

回答2:

while not rsex.eof
i = 1
while i < j+1
sqlis = "insert into " & tablename & "([field"& i &"]) values('"& fixsql(rsex(i - 1)) &"')"
ADOConn.execute(sqlis)
i = i + 1
wend
rsex.movenext
wend
这样试试
以上回答你满意么?