摘要: --当天: select * from T_news where datediff(day,addtime,getdate())=0 --最近三天: select * from T_news where datediff(day,addtime,getdate())= 0 --本周: select * from T_news WHERE (DATEPART(wk, addtime) =... 阅读全文
posted @ 2018-09-01 20:45 兰博丶专属 阅读(1235) 评论(0) 推荐(0) 编辑
摘要: ROW_NUMBER() OVER (ORDER BY (select Null)) AS Id entity framework 查询中有这句会有异常 阅读全文
posted @ 2018-09-01 20:08 兰博丶专属 阅读(2047) 评论(0) 推荐(0) 编辑