04 2014 档案

Sql 查询 笛卡尔积
摘要：收藏SQL查询cross join 的用法(笛卡尔积)select a.Dealer, a.ProductCategoryI, a.CalendarYear, ('Q' + cast(a.CalendarQuarter as nvarchar(4))) as CalendarQuarter, sum(b.AmountUSD)as AmountUSD from(select e.Dealer, b.ProductCategoryI, b.CalendarYear, d.CalendarQuarterfrom DimDate a full join (select ... 阅读全文
posted @ 2014-04-03 16:01 Neomi 阅读(894) 评论(0) 推荐(0)
Sql Server 导入Excel数据 插入只读列
摘要：到这一步, 钩上 启用标识插入 就可以了 阅读全文
posted @ 2014-04-02 09:53 Neomi 阅读(238) 评论(0) 推荐(0)