举个例子,用ASP写的
Set rs = conn.execute ("Select id,name from Table")
Do while not rs.eof
Set rs2 = conn.execute ("Select userid,school from Table2 where userid = "&rs("id") )
dim gets = ""
Do while not rs2.eof
gets = gets&rs2("school")&"<br>"
rs2.movenext
Loop
rs.movenext
loopresponse.write gets请问用存储过程怎么写?一定要用游标吗?
Set rs = conn.execute ("Select id,name from Table")
Do while not rs.eof
Set rs2 = conn.execute ("Select userid,school from Table2 where userid = "&rs("id") )
dim gets = ""
Do while not rs2.eof
gets = gets&rs2("school")&"<br>"
rs2.movenext
Loop
rs.movenext
loopresponse.write gets请问用存储过程怎么写?一定要用游标吗?
select @str=isnull(@str,'') + "<br/>" + b.school
from [table] a
inner join table2 b
on a.id=b.userid
select stuff(@str,1,5,'')
我只是想知道按循环方式如何来解决这个问题。?