How to return data after an insert sql?

Now I have a simple insert statement returns a boolean is a - OK or not.
Is it possible to make that insert returns either id of the added entry or the whole record entirely without the use of extra queries?
March 23rd 20 at 19:09
1 answer
March 23rd 20 at 19:11
Solution
@@IDENTITY
Or get a key.
Um, the example does not show, please tight until it comes, how can you not SELECT to use it? - Federico_Botsford commented on March 23rd 20 at 19:14
@Federico_Botsford, You are not listed as
insert returns a boolean
- jennie.Torp commented on March 23rd 20 at 19:17

Find more questions by tags SQL