Hello,
Currently there is no way to return the GUID inserted automatically in the table. While the solution Suhas gave you works, it is a workaround to the problem.
Select @@identity will return the value of last Identity value inserted. This is an integer datatype and it doesn't apply in your case.
Thank you,
>I know this question has been asked a dozen times before, but I can't seem to locate the answer.
>
>My SQL table auto-generates a GUID primary key for newly inserted records. Is there a way for me to grab that value during or after my insert statement?
>
>TIA
Grigore Dolghin
Class Software.