sqlserver常用语句

最新推荐文章于 2024-04-11 22:20:19 发布

飞龙剑

最新推荐文章于 2024-04-11 22:20:19 发布

阅读量423

点赞数

分类专栏： sqlserver 文章标签： sqlserver sql string action table

本文链接：https://blog.csdn.net/feilongjian001/article/details/6921744

版权

sqlserver 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

模糊查询分页语句

String sql = "SELECT TOP "+currentCount+" * FROM (SELECT ROW_NUMBER() OVER (ORDER BY LOG_ID) AS RowNumber,* FROM T_CONT_LOG " +
        "WHERE LOG_ID LIKE '%"+likeStr+"%' OR REQUEST_IP LIKE '%"+likeStr+"%' OR REQUEST_TIME LIKE '%"+likeStr+"%' " +
        "OR REQUEST_SQL LIKE '%"+likeStr+"%' OR REQUEST_ACTION LIKE '%"+likeStr+"%' OR TABLE_NAME LIKE '%"+likeStr+"%') A " +
        "WHERE A.RowNumber > "+currentCount+"*("+currentPage+"-1)";

模糊查询获得总记录数：

String sql = "SELECT COUNT(*) FROM T_CONT_LOG WHERE " +

"LOG_ID LIKE '%"+likeStr+"%' OR REQUEST_IP LIKE '%"+likeStr+"%' OR REQUEST_TIME LIKE '%"+likeStr+"%'" +
" OR REQUEST_SQL LIKE '%"+likeStr+"%' " +
"OR TABLE_NAME LIKE '%"+likeStr+"%' OR REQUEST_ACTION LIKE '%"+likeStr+"%'";

查询分页：

String sql = "SELECT TOP "+currentCount+" * FROM T_CONT_LOG WHERE LOG_ID NOT IN (SELECT TOP ("+currentCount+"*("+currentPage+"-1)) LOG_ID FROM T_CONT_LOG ORDER BY LOG_ID) ORDER BY LOG_ID ";