摘要: 1.建表 2.导入IIS日志 3.查询 select LEFT([time],5),COUNT(1) cnt from [inetlog0828] GROUP by LEFT([time],5) order by cnt desc 4.合并date和time,并处理UTC时间 5.bulk inse 阅读全文
posted @ 2015-08-28 15:42 davidhou 阅读(757) 评论(0) 推荐(0) 编辑