how to get last inserted identity value after insert operation

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

how to get last inserted identity value after insert operation

leks
Hi All

I need to get last inserted ID after I insert record into the table with " ID INT GENERATED ALWAYS AS IDENTITY NOT NULL PRIMARY KEY"

how to do it?

thank you.

Aleksey