思路话语

。Arlen:思想有多远你就能走多远...

03 2009 档案

DataTable.Merge 时出现DataType不致 int32 int64
摘要:DataTable1的sql:select distinct a.*,t.id as serverid,b.id as deptid,....DataTable2的sql:select distinct a.*,0 as serverid, 32 as deptid,...在调用dt1.Merge(dt2)的时候,由于两个serverid字段类型不一致,一个int32,一个int64,导致无法Me... 阅读全文

posted @ 2009-03-13 15:56 Arlen 阅读(1455) 评论(0) 推荐(0)

sql 计算子字符串在父字符串中出现次数的一个非常简单的办法
摘要:select length(sn)-length(replace(sn,',','')) from ...update ads_netdevice_info set islogic=length(sn)-length(replace(sn,',',''))+1 阅读全文

posted @ 2009-03-12 15:30 Arlen 阅读(648) 评论(0) 推荐(0)

导航