Hi Frank.

When does this table get deleted? when the DB connection closes or does one have to run a process to clear the temp tables?

On Tue, 2003-12-16 at 17:29, Frank M. Kromann wrote:

Any table that starts with # is a temp table. You can use

create table #mytemp (...) or you should be able to use the query you
suggest. You just have to make sure you have enough space in tempdb (a
system database)

- Frank

> Hi all,
> I've been handed a query which I'm trying to get to work.  I'm using PHP

> to talk to MSSQL 7.
> My question is this:  Can I create temp tables with mssql without 
> executing the code in a stored procedure? 
> The simplified version of the query is as follows:
> $query = "SELECT distinct convert(varchar(36),traineeID)";
> $query.=" INTO #tempdata1";
> $query.=" FROM    tblSignIn_trainee a";
> Later on I could make a stored procedure, but at the moment I would like

> to just work with the query directly in the code if at all possible.
> Thanks,
> John
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
Matthew Vos
Systems Analyst
Product Development
Techcom Software Solutions Inc.

* * * * * * * * * *
This message contains information from Techcom Software Solutions Inc.
which is confidential and privileged.  If you are not an intended
recipient, please refrain from any disclosure, copying, distribution or
use of this information and note that such actions are prohibited.

If you have received this transmission in error, please notify

This message and any attachments have been scanned for viruses.
This message has been digitally signed to ensure authenticity.
Fingerprint: 009F E13D 0450 55AF DC1C 4D77 1FE9 0DBB CFEA 28EC

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to