how can i create temp table in ms-sql

[GoogleCodeExporter]

I use MS-SQL 2008 R2.

simple source pattern i want to use is below.



<select id="select" parameterClass="Hashtable" resultMap="resultCls"  >

CREATE TABLE #LTABLE(A INT)

INSERT #LTABLE(A) VALUES(1)

SELECT * FROM #LTABLE

</select>

Original issue reported on code.google.com by quardia...@gmail.com on 8 Oct 2013 at 2:45