Posted by Erland Sommarskog on 10/31/05 01:05

serge (sergea@nospam.ehmail.com) writes:
> So my question is should I do this by using sp_binddefault or stick
> with using Default Constraints inside a table/columns loop code?

Bound defaults and rules are great for user-defined types, and as long
Microsoft does not provide real domains, they should just not think of
dropping these constructs.

But if you are working with individual columns, there is no reason to
use bound defaults and rules. Use constraints instead.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
• Prev in forum: Re: Creating Tables on the Fly
• Thread view: Re: Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?

[Reply to this message]