Viewing 3 posts - 1 through 3 (of 3 total)
Interesting article. Most of things are well known, but here they are summarized and there are also some interesting ideas.
The most...
May 31, 2006 at 4:07 am
#640859
Answer is not fully correct. If the new column is NOT NULL, then your default value will be applied to all existing records, too.
September 7, 2004 at 12:34 am
#521916
"USE pubs" switches context to pubs database!
By the way the SQL code in this question is 1 to 1 copy of "SET FMTONLY" articel in SQL Server Books Online!
July 9, 2004 at 12:01 am
#513977