In SQL Server one can query the last created indentity value as such:
INSERT INTO .....
SELECT @@IDENTITY AS 'Identity';
I am trying to acheive the same in a database operation file (.esbdb). However I am unable to escape the @ character. It tries to interpret those as query parameters. Any way to achieve this?
I am using Sonic 7.6.2
Thanks
Raji