### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 必须声明表变量 "@P0"。

; uncategorized SQLException for SQL []; SQL state [S0001]; error code []; 必须声明表变量 "@P0"。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 必须声明表变量 "@P0"。

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:)

    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:)

    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:)

    <select id="queryList" resultType="Map" databaseId="sqlserver">

        SELECT * FROM

        (

        SELECT

                D.*, ROW_NUMBER () OVER (ORDER BY TmStamp DESC) RN

        FROM

                ${tableName} D

        ) T

        <if test="limit!=null and offset!=null">

            WHERE RN&lt;=#{limit}+#{offset} AND RN&gt;#{offset}

        </if>

    </select>