How to set a default value for an existing column
ALTER TABLE dailyView ADD DEFAULT getdate() FOR st