sqlserver top 不支持占位符

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