Thanks to Lou Schilling for pointing me back to why I originally started blogging on SQL Junkies. I started with the intention of talking about SQL and sharing whatever little knowledge I had, but somewhere down the line I deviated and started blogging about whatever I found interesting. I agree, that this one of the best sites for SQL related stuff , we should keep our personal rants to a minimum.
Ok!! Back to talking about SQL ...
One of the latest discoveries I have made (at least it was a discovery for me ...) is
CREATE DEFAULT
and
sp_bindefault
As for me, I find them identical in purpose to the User-defined data types ...
However .. this is what worries me ....
Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements.
Is this still there in SQL Server 2005 or not ???
Watch out for an article on the same topic on SQL Junkies soon !!!