title: Best way to get PK Guid of inserted row
body: <p>I've read <a href="https://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row">this question</a> about getting the identity of an inserted row.  My question is sort of related.</p>
  
  <p>Is there a way to get the guid for an inserted row?  The table I am working with has a guid as the primary key (defaulted to newid), and I would like to retrieve that guid after inserting the row.</p>
  
  <p>Is there anything like <code>@@IDENTITY</code>, <code>IDENT_CURRENT</code> or <code>SCOPE_IDENTITY</code> for Guids?</p>