- 博客(5)
- 资源 (10)
- 收藏
- 关注
原创 sql删除重复行
delete [Payment] from [Payment] inner join( select ID from (select *,ROW_NUMBER() over(partition by Policy_No,PTD_Start order by PTD_Start) as rowno from [Payment])Twhere rowno>1) T2 --查询行号大于1的记录
2012-12-29 13:36:34 357
原创 缓存管理公用类(通过委托更新缓存)
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Web; namespace Cache{ public class IListCache { public delegate IList
2012-12-29 13:24:46 527
原创 初始化随机种
Random Counter = new Random(Guid.NewGuid().GetHashCode()); 测试例子 Random Counter = new Random(Guid.NewGuid().GetHashCode()); Response.Write(Counter.Next(1, int.MaxValue))
2012-12-29 13:10:50 527
原创 判断两个时间段是否有交集
时间段:starttime_1到endtime_1,starttime_2到endtime_2SQL语句:where least(endtime_1, endtime_2) > greatest(starttime_1, starttime_2)解释:least取最小值,greatest取最大值。创建函数least、greatestCREATE FUNCTION least(
2012-12-29 12:59:30 3696
远程桌面连接工具(可保存多个连接和密码)
2011-09-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人