title: Setting Value of One Column same as another column in a table during insert
body: <p>I have a table <code>Line_Production_Plan</code> in SQL Server; it has a <code>UID</code> column (int, auto-increment, identity).</p>
  <p>It also has multiple other columns. One of them is <code>execution_priority</code> (int, not null).</p>
  <p>When I insert a new row into the table (via a stored procedure (without passing <code>execution_priority</code> or <code>UID</code> as parameters)), I want <code>execution_priority</code> to take up the same value as the corresponding <code>UID</code> column in during insert. Is there a way to set the default value of a column, equal to another upon insert?</p>
  <p>The execution, priority needs to be changed from time to time. Hence I can't use identity or auto increment.</p>