数据库中已存在名为 '#T1' 的对象

IF OBJECT_ID('tempdb.dbo.#T1') IS NOT NULL DROP TABLE #T1

IF OBJECT_ID('tempdb.dbo.#T2') IS NOT NULL DROP TABLE #T2

应该也不会有问题

dim SQL

select case request.form("city")

case "0"

'显示指定的ID=1，name和TT的数据

SQL="select * from mobile where id='"&request.form("city")&"'"

case "1"

SQL="select * from mobile where id='"&request.form("city")&"'"

end select

set rs=server.CreateObject("adodb.recordset")

rs.open sql,db,1,1

if not rs.eof then

response.write rs("name")&" "&rs("name")

set rs=nothing

end if

%>