高级SQL语句

分页
Select top {0} * from PLUS_SMS where (s_id not in (select top {1} s_id from PLUS_SMS order by s_id desc)) order  by s_id desc
-- {0}为页大小 由0开始，{1}为页码*页大小

返回最新ID
select IDENT_CURRENT('PLUS_SMS')
--'PLUS_SMS' 为表名
----------------------------------------
insert into PLUS_NUMBER values('1561651',1)
select @@Identity
-- 插入立即返回ID