Guys,
I'm looking to run a query which creates a SQL Server temporary table. This
has got me a little confused as the SQL requires to have a # in the midst of
it to create the table.
What's the correct syntax for this? Do I use a double ## or a triple ###?
For instance, if I have a query like so:
<cfquery name="LOCAL.qCreate" datasource="MyDSN">
CREATE TABLE ##MessageStaging (....
Is that creating a temp table? Of is the ## just an nonexistent value and
its creating a physical table?
I'd appreciate your thoughts guys,
Robert
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312886
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
