Solved

SQL - Need to create a temporay table

Posted on 2007-12-05
2
160 Views
Last Modified: 2010-04-21
I'm working in ColdFuison and i need to create a temporary MS SQL 2000 table.
<cfquery name="createTempTable" datasource="#dbname#" username="#dbuser#"passsword="#dbpw#">
CREATE TABLE #tmp_report_table
(name      VARCHAR(30),
id            int(4),
level      int(4)
)
</cfquery>

What i'm i doing wrong?
0
Comment
Question by:Wirt
2 Comments
 
LVL 23

Accepted Solution

by:
Ashish Patel earned 500 total points
ID: 20412620
#temp tables are will just exists untill your current connection state or execution and they get dropped as soon as your execution scope is over. So, its good if you create a table without # prefix in tempdb database for your use.
0
 

Author Closing Comment

by:Wirt
ID: 31412880
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 18 99
How to manage encyps queries mssql when sending conditioning values 10 37
Query Records that don't match 8 32
SQL Error in WHERE Clause 5 38
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now