When I insert a new row into a table, and one of the field's uses a
generator, how can I get that value of that generated field? Do I need
to write a stored procedure to do this? Something like:

ID = GEN_ID('xx', 1);
INSERT INTO Table... (using ID)
return ID

Or is there something along the lines of SQL Server's "SELECT
@@IDENTITY"?

Cheers,
Diego