2015 年 7月随笔档案 - wolf12

用于dbnull的数据转换。因为用convert.to无法转换dbnull类型

摘要：/// <summary> /// add by wolf /// </summary> public static class ExtendObject { public static bool IsTargetType<T>(this object source) where T : IConv 阅读全文

posted @ 2015-07-31 08:50 wolf12 阅读(439) 评论(0) 推荐(0)

sqldbhelper

摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Configuration;using System. 阅读全文

posted @ 2015-07-31 08:41 wolf12 阅读(217) 评论(0) 推荐(0)

sql 去重

摘要：;WITH CETAS (SELECT *, ROW_NUMBER() OVER (PARTITION BY SearchTask_PKID ORDER BY SearchTask_PKID) RowNo FROM [SiteAnalysis].[dbo].[UrlQueue] ) DELETE C 阅读全文

posted @ 2015-07-16 16:13 wolf12 阅读(148) 评论(0) 推荐(0)