[dba-SQLServer] SQL 2000 question

Stuart McLachlan stuart at lexacorp.com.pg
Sun Apr 22 19:23:48 CDT 2012


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?
> 



More information about the dba-SQLServer mailing list