getting the 'id' of a new record

[Anon]

I have a SQl statment that does an insert into th db. How can I get the 'id' of this new record?

Thanks

[kparker]

Depends on which dbms you are using. Say more...