One "temp"-table-like feature I *love* that MS SQL Server does is
table-variables.

If you're unfamiliar, a table can be declared into memory as a variable and
is removed from memory once the query or procedure is finished executing.

They're faster than temp-tables with cursors because they're less tangible,
for lack of a better term, and are only temporarily stored in memory.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
de-dz_66w5.asp

I'd be thrilled if FB ever had this feature!

-v

_____

From: Daniel Rail [mailto:daniel@...]
Sent: Friday, December 17, 2004 4:35 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Temporary tables


Hi,

At December 17, 2004, 15:50, Garrett Smith wrote:

> Storage Box wrote:
>> Also, sometimes it's better to query more than once to get
>> values+sub-values than it is to make a single monster of a
>> joined/union query.

> This is the design approach I'm taking (and have taken with other
> dbmses), but lack of temp tables and/or subqueries is making it
> difficult.

Subqueries will be available in FB 2.0. And, the requirement for temp
tables has been talked about lately, but no consensus on how to
implement them has really been reached, because there are a few models
to choose from on how to implement them and the SQL standard does
differ to MS-SQL temp tables.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129025tq5/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705115386:HM/EXP=1103413103/A=2455396/R=0/SIG=119u9qmi7/*http://smal
lbusiness.yahoo.com/domains/> click here

<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2455396/rand=180514878>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]