how can i create temp table in ms-sql

chanxianzhong / mybatisnet

Automatically exported from code.google.com/p/mybatisnet

0 stars 0 forks source link

how can i create temp table in ms-sql #57

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

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