13709394 - 2007-4-9 20:27:00
这段asp脚本在DNT后台运行SQL脚本该怎么写?
set rs=server.createobject("adodb.recordset")
sql="select * from a order by userid"
rs.open sql,conn,1,1
do while not rs.eof
conn.execute("update b set username="&rs("username")&" where userid='"&rs("userid")&"'")
rs.movenext
loop
急求
13709394 - 2007-4-9 21:02:00
会的帮帮忙吧,谢了!!!!!!!
Sitwo - 2007-4-9 21:17:00
UPDATE [b] SET [username]= [a].[username] FROM [a] WHERE [a].[userid] = [b].[userid]
13709394 - 2007-4-9 21:28:00
谢谢,不用循环语句的吗?
Sitwo - 2007-4-9 21:59:00
不用，一句搞定~:)