摘要: #region 多条件搜索时,使用List集合来拼接条件(拼接Sql) StringBuilder sql = new StringBuilder("select * from PhoneNum"); List<string> wheres = new List<string>(); if (cbo 阅读全文
posted @ 2016-06-30 15:15 kaikaichao 阅读(3600) 评论(0) 推荐(0) 编辑
摘要: 1. ROW_NUMBER() 的分页方法 DECLARE @currentPage INT =2,@pageSize INT =5; WITH cte AS( SELECT ROW_NUMBER() OVER(ORDER BY OrderId desc) rowid,* FROM dbo.EC_O 阅读全文
posted @ 2016-06-23 13:57 kaikaichao 阅读(164) 评论(0) 推荐(0) 编辑