How to set default value for Time(7) data type in SQL Server 2008


You can set a default value for time7 data type from  SSMS: (’00:00:00′) as the default value.

Or use this query:

ALTER TABLE  yourTable ADD  CONSTRAINT [DF_time7Column]  DEFAULT ('00:00:00.0000000') FOR [time7Column]
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s