select top #{end} * from SMS_SERVICE_FIELD where C_COMPNT_ID = #{compntID} order by C_FLD_ID ASC
sqlserver top 不支持占位符
采用字符拼接形式
select top ${end} * from SMS_SERVICE_FIELD where C_COMPNT_ID = #{compntID} order by C_FLD_ID ASC
select top #{end} * from SMS_SERVICE_FIELD where C_COMPNT_ID = #{compntID} order by C_FLD_ID ASC
sqlserver top 不支持占位符
采用字符拼接形式
select top ${end} * from SMS_SERVICE_FIELD where C_COMPNT_ID = #{compntID} order by C_FLD_ID ASC