I'll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: Or
How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?