temp table && check temp table

生成temp表
select * into #Temp_a  from a

'驗測是否在temp表
  sql="select isnull(OBJECT_ID('tempdb..#Temp_material'),0) as temp,"&_
      "isnull(OBJECT_ID('tempdb..##Temp_material_A'),0) as temp_A,"&_
      "isnull(OBJECT_ID('tempdb..##Temp_material_B'),0) as temp_B"
  set rs=conn.execute(sql)
  if (rs(0)<>0 or rs(1)<>0 or rs(2)<>0) then
    msg="系統正忙，請過段時間再查詢．"
    response.Write("<script language='javascript'>alert('"&msg&"');</script>")
    rs.close
    conn.close
    response.end()
  end if
  '檢查結束