"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.
Received on Wed Sep 24 2003 - 08:56:27 CDT
