I use SQL Server for store database.
And use Trigger to generate the primary key for new records.
I have problem when I write a programme on Winform:
When I insert a record into database, I wanna know what the key SQL gennerate for it is so that I can use it for the future.
Show is any good way to do that?