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
asked 31 Mar '14, 19:33
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 :)