How to create default constrant for a column of a table
ALTER TABLE [dbo].[PolicyRecord] ADD CONSTRAINT [DF_PolicyRecord_LastChangeTime] DEFAULT (getdate()) FOR [LastChangeTime]
Common sql statement
原文：http://www.cnblogs.com/vision668/p/6362244.html
