SqlServer
SqlServer
Thinbug
精雕细琢,匠心之道.
展开
-
SQL:根据消费类型不同统计人次
SQL:根据消费类型不同统计人次--按照不同消费类型,统计不同类型的总金额和玩家(重复消费算1人次)select distinct reason,sum(c) as '金额', count(unick) as '人数' from (select unick,reason,sum(cost) as c from rp_usercost group by unick,reason ) tgroup原创 2015-09-29 17:01:09 · 2575 阅读 · 2 评论 -
匹配数据库GO,用来分隔多个SQL程序读取
匹配数据库GO,用来分隔多个sql程序读取sql = System.Text.RegularExpressions.Regex.Replace(sql, @"[^a-zA-Z0-9]go[^a-zA-Z0-9]","\r\nGO\r\n", System.Text.RegularExpressions.RegexOptions.IgnoreCase);string[] sqlbuffer = Sy原创 2016-11-11 14:25:39 · 443 阅读 · 0 评论