Retrieve last inserted ID DataSnap / SqlServer [duplicate]

Ailton I use a lot of these two options that sql server gives:

IDENT_CURRENT returns the last identity value generated for a specific table in any session and scope. But you need to ensure that your insert worked, otherwise it will pick up the last Identity from the table even without inserting anything.

Ex: SELECT IDENT_CURRENT ('KEY_NAME')

GO

SCOPE_IDENTITY returns the last generated Identity value for any table in the current session and scope. This is clear that you should also ensure the INSERT worked, the difference being that instead of looking directly at the table it looks at the current session that it was run, ie it will just get the Identity generated in that session.

Ex: SELECT SCOPE_IDENTITY ()

GO

The result of both options you can store in a variable and manipulate it any way you want.

In the function that you pass the client data to the server insert into the database, put "out variable" the out returns you the return of a given.