How to properly return data after insert sql?

Question

SQL

Now at me at simple insert returns boolean - everything is OK or not.
Whether it is possible to make, that at insert returned either id of the added record, or all record entirely without use . requests?

Answer 1

@@IDENTITY
Or getting a key .