title: How can I get the GUID value of a new row after inserting it?
body: <p>I am trying to get the Id of newly inserted record in Sqlserver. I have checked the <code>Scope_Identity()</code> but this is said to return the value of the autoincrement column. The column I am using for Id is Guid. I want this Guid column value after the insert. How should this be achieved? Or I must have to write a custom tedious function to get the Id of newly inserted record.</p>