title: use select statement in default while declaring a table
body: <p>I want to set a default value to a column while declaring a table , but the value is not constant , actually it's based on some other data from another table . 
  I'm interested to know if there is such thing like code below is SQL-server :</p>
  
  <pre><code>create table Test_Table(
  Id int primary key ,
  Name varchar(50),
  Sum int default (select Count(*) from AnotherTable where Condition)
  )
  </code></pre>