Re: Why Not Allow Temp Tables?

Ryan Gaffuri wrote:

>"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3f7177e2$0$15785$ed9e5944_at_reading.news.pipex.net>...
>
>
>>"(Pete Cresswell)" <x_at_y.z> wrote in message
>>news:7dvumv0n9nef438hgrfc1fea9c8ejf1sah_at_4ax.com...
>>
>>
>>>RE/
>>>
>>>
>>>>Personally, I think you are going to find that the person who wants temp
>>>>tables probably is from a non-Oracle background (eg Sybase or SQLServer)
>>>>where they are used all the time for a variety of reasons.
>>>>
>>>>
>>>Bingo!.... SQL Server...
>>>-----------------------
>>>PeteCresswell
>>>
>>>
>>I'd expect in a lot of cases you won't even need a GTT. In MSSQL you might
>>well wish temp tables to avoid locking issues, in Oracle you won't get those
>>locking issues.
>>
>>
>
>i hear about temp tables in sql server all the time. are they
>implemented like global temp tables in oracle? im not familiar with
>the sql server architecture.
>
>

SQL Server doesn't have temp tables. It has heap tables people use for temporary storage to get around
the lack of locks and the fact that writes block reads and reads block writes.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)