@Sudeep: Yes, most tables have PK-FK relationships and hence this approach won't work, but it does work when inserting data for columns that store flags. For example, if a system implements soft-delete, most records that get inserted are active records. Therefore, the BIT flag that would be storing this value can have a DEFAULT value of 0. That way, the application does not have to hard-code the 0.
That's just one of the scenarios where DEFAULT values can be used.
commented on May 24 2012 12:40PM