摘要:
Data Mining with SQL Server 2005(数据挖掘技术) 一、数据挖掘技术可以解决的一些典型商业问题。客户流失分析交叉销售欺诈检测风险管理客户细分广告定位销售预测 二、数据挖掘的任务分类聚类(细分)关联(购物篮分析)回归预测序列分析(主要应用于WEB日志分析和DNA分析)偏差分析(孤立点检测) 三、数据挖掘项目的生命周期数据收集数据清理和转换 数据类型转换连续列转换(把值连... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--declare@ttable(idint,statuschar(1),UpdateDatedatetime,primarykey(id,updatedate))insertinto@tselect1,... 阅读全文
摘要:
代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--DECLARE@T1table(UserIDint,UserNamenvarchar(50),CityNamenvarchar(50));insertinto@T1(UserID,UserName,... 阅读全文
摘要:
代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--selectobject_name(fkeyid)FK_Table,object_name(rkeyid)PK_Table,b.nameFK_Column,c.namePK_Columnfromsy... 阅读全文
摘要:
代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--declare@iintdeclare@tTPIDtable(tpidintnotnullidentity(1,1)primarykey)declare@tTUIDtable(tuidintnotn... 阅读全文
摘要:
Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->declare @sql varchar(max), @column_name varchar(200); set @sql = ''; set @column_n... 阅读全文