I'd like to set the default value of a column in a table equal to the value of another column in the same table. This is a temporary vlue until it get's updated later. I need the column to be unique, so this is why I am setting it equal to the key value initially.
How do I indicate this default (if possible). I can do it programatically on the insert.
FYI. I'm using MS SQL Server 2005
Thanks, in advance,