[dba-SQLServer] SQL 2000 question

Thanks, Stuart. I know what they are and what to do with them. I just
wasn't sure whether global temp tables were available in SQL 2000.
Francisco assures me that they are.

A,

On Sun, Apr 22, 2012 at 8:23 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> Quick google came up with:
>
> http://www.sqlservercentral.com/articles/T-SQL/temptablesinsqlserver/1279/
>
> There are two types of temporary data types. They are namely Local and
> global. Let me first
> give you and example to start the temporary table. Following example is
> taken from Books on
> Line of Microsoft® SQL ServerTM 2000.
>
> --
> Stuart
>
>
> On 22 Apr 2012 at 19:59, Arthur Fuller wrote:
>
> > It's been several years since I have had SQL 2000 installed locally, but
> > lately I've had occasion to use it. Fortunately, SQL 2005 is also
> > installed, so I can use SSMS instead of resorting to the dinosaur
> > Enterprise Manager.
> >
> > Currently, there are 5 procs executed in sequence. Each uses one
> particular
> > table, scoping it by a date range and another parameter, then joins the
> > result to a second table to obtain values to update the original table.
> The
> > procs are always executed in sequence.
> >
> > Now, my question. Does SQL 2000 support global temp tables?
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr