sqlserver常用语句

发布时间：2020-12-12 14:52:56 所属栏目：MsSql教程来源：网络整理

导读：?模糊查询分页语句 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_TIM

?模糊查询分页语句

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 ";

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!