数据仓库的时间维度表 Sql
Declare @BeginDate Datetime Set @BeginDate='2011-1-1' While @BeginDate Begin Insert Into [InstagramDataDW].[dbo].[Dim_Date] Select CONVERT(varchar(10),@BeginDate,112) As DateKey,Year(@B