title: How to set default value for column from another table in SQL Server 2005
body: <p>Is it possible in SQL Server 2005 to set a default value for a column which comes from another table through a query or something?</p>