|
With ASA 9.0.2, is there a way to use: SELECT ColName INTO #temp FROM ExistingTable but give #temp the NOT TRANSACTIONAL quality, as if it were declared with this: DECLARE LOCAL TEMPORARY TABLE #temp(ColName) NOT TRANSACTIONAL |
|
I am fairly certain the answer is "no, not for ASA 9.0.2, not for SQL Anywhere 16, not for any version". ...which is too bad, because SELECT ... INTO #temp is such an incredibly powerful construction... because you don't have to explicitly define data types... you can even use SELECT * to create a table without specifying the columns AT ALL; e.g., SELECT * INTO #t FROM rowgenerator CROSS JOIN dummy; Powerful, yes, but apparently folks aren't lining up to demand NOT TRANSACTIONAL for it :) |
