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

  '檢查結束