title: define a computed column reference another table
body: <p>I have two database tables, <strong>Team</strong> (<code>ID, NAME, CITY, BOSS, TOTALPLAYER</code>) and 
  <strong>Player</strong> (<code>ID, NAME, TEAMID, AGE</code>), the relationship between the two tables is one to many, one team can have many players. </p>
  
  <p>I want to know is there a way to define a <code>TOTALPLAYER</code> column in the <code>Team</code> table as computed? </p>
  
  <p>For example, if there are 10 players' <code>TEAMID</code> is 1, then the row in <code>Team</code> table which <code>ID</code> is 1 has the <code>TOTALPLAYER</code> column with a value of 10. If I add a player, the <code>TOTALPLAYER</code> column's value goes up to 11, I needn't to explicitly assign value to it, let it generated by the database. Anyone know how to realize it? </p>
  
  <p>Thx in advance.</p>
  
  <p>BTW, the database is SQL Server 2008 R2</p>