Re: Drop temporary tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Viviana Kern (anonymous_at_discussions.microsoft.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 14:07:15 -0700

Hi Aaron
One DBA tells me that a Microsoft's Engineer recomended to
ommit this sentence.
I try it and in some procedures it's faster and in others
don't.
That's why I'm asking.
TIA

>-----Original Message-----
>It's safer, though #temp tables do automatically get
dropped when the proc
>goes out of scope.
>
>Out of curiosity, do you expect to gain anything by not
including it?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>"Viviana Kern" <anonymous@discussions.microsoft.com>
wrote in message
>news:1996501c44d96$cb7fccc0$a601280a@phx.gbl...
>> I need to know if it's better to exec the sentence drop
>> table #temprary_table in stored procedure or not.
>> TIA
>
>
>.
>

Relevant Pages

  • Re: Using a form ..... how do I
    ... dba scribed: ... |TIA ...
    (alt.html)
  • problem with exec and locals()
    ... the following code does not work until I ommit the "a=0" statement. ... def test: ... exec "a=3" in locals ... UnboundLocalError: ...
    (comp.lang.python)
  • Re: Drop temporary tables
    ... > Hi Aaron ... > One DBA tells me that a Microsoft's Engineer recomended to ... > ommit this sentence. ... If you could show a repro, ...
    (microsoft.public.sqlserver.programming)
  • Re: setgid failed : Not owner
    ... | i have a app which runs as root. ... |must run as oracle user and dba as group. ... |When i call setgidbefore exec, it fails with error: ...
    (comp.sys.hp.hpux)
  • Developer turnd DBA, where to go for a good Security primer?
    ... I have taken a position as DBA where I have been doing some development ... I'm looking for a list of precautions to follow or at least a white paper ... with banks. ... TIA ...
    (microsoft.public.sqlserver.security)