iteye_11197的博客

用ibatis 返回sqlserver主键自增值[code="java"] select @@IDENTITY as value [/code]返回mysql主键自增值[code="java"] SELECT LAST_INSERT_ID()[/code]

sql server row number分页：[code="java"] select b.* FROM ( select row_number() over(order by t.id desc) as rownumber, t.* from table_name t ) as b where b.rownumber <= #endIndex# and b...