Do a SELECT @@IDENTITY statement to get last PK inserted into your SQL table.

>How do I get the PK value assigned by SQL Server right after adding a new record to a table? I tried to search UT but the search area is down. Thus, I am sorry for a very basic question, I am sure it was asked before.
>
>Thank you in advance.