Manually creating default constraints in SQL Server

Default constraints can be added in Management Studio by setting a default value for a field in the designer, or by specifying it in your table create script. This SUCKS though, because it generates a random name for the constraint, which can lead to inconsistencies across databases - if you... [Read More]
Tags: sqlserver