Wirt
asked on
SQL - Need to create a temporay table
I'm working in ColdFuison and i need to create a temporary MS SQL 2000 table.
<cfquery name="createTempTable" datasource="#dbname#" username="#dbuser#"passswo rd="#dbpw# ">
CREATE TABLE #tmp_report_table
(name VARCHAR(30),
id int(4),
level int(4)
)
</cfquery>
What i'm i doing wrong?
<cfquery name="createTempTable" datasource="#dbname#" username="#dbuser#"passswo
CREATE TABLE #tmp_report_table
(name VARCHAR(30),
id int(4),
level int(4)
)
</cfquery>
What i'm i doing wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER