使用GETDATE填充SQL中的列

I have a Dimension Table (as part of a data mart) with a DateTime field called 'Date'. I'd like to derive more info from Date though, so I have added additional fields for the number of the month , day number, etc ( these additional fields are currently un-populated.) I have a Dimension Table (as part of a data mar