Success code for insert statements

If I use an insert statement in a query, is it possible to get a success code when it executes? I would like to verify that it succeeded.

Thank you.