摘要: var numString = '122'; var numberInt = Number(numString); var res = numberInt/2; 结果: res = 61 阅读全文
posted @ 2016-12-21 13:49 wangwei_Carry 阅读(880) 评论(0) 推荐(0)
摘要: 1 : 多个表联合查询 select j.id, jt.Name, j.ApproveType , j.ProductCode, j.CustomerCode, u.FullName, jf.Name as jfName, j.ExpectedTime from JudgeOrder as j jo 阅读全文
posted @ 2016-12-21 13:36 wangwei_Carry 阅读(206) 评论(0) 推荐(0)
摘要: 1 , select j.id, jt.Name, j.ApproveType , j.ProductCode, j.CustomerCode, u.FullName, jf.Name as jfName, j.ExpectedTime from JudgeOrder as j join Judge 阅读全文
posted @ 2016-12-21 13:33 wangwei_Carry 阅读(4486) 评论(0) 推荐(0)
摘要: 1 通过sql实现分页。 select top 5 * from judgeorder where id not in (select top 10 id from judgeorder order by id) order by id 通俗点讲: 选择不在前十条记录中的前五条记录。也就是第 11 阅读全文
posted @ 2016-12-21 09:42 wangwei_Carry 阅读(626) 评论(0) 推荐(0)