title: Data import SQL Server 2008
body: <p>I'm adding data into a table in my database from a VB application. But, I need to know, is it possible that some of the data I added can be imported to another table?</p>
  
  <p>example:</p>
  
  <pre><code>table1(ID,FisrtName,LastName) data are added completely  
  table 2 specific (FirstName, LastName)  
  </code></pre>