title: vb.net sqlclient insert output
body: <p>I have a ms sql table PRODUCTS.
  And it has three columns ID (int),NAME (nvarchar),TSTAMP (timestamp)</p>
  
  <p>I want to get new inserted row's both id and timestamp (like multiple select scope_identity).
  I can achieve that in sql as following:</p>
  
  <pre><code>INSERT INTO PRODUCTS (NAME)
  OUTPUT inserted.ID,inserted.TSTAMP
  VALUES ('Example Product')
  </code></pre>
  
  <p>But how can i read it in vb.net with sqlclient.sqlcommad on insertation? Which function of sqlcommand do i have to use and how? ExecuteReader maybe?</p>