How to use insert and select simultaneously?
So is it possible to do insert and select simultaneously?


Yes, you can use the output clause of the insert statement.

insert into dbo.Test(age) 
output inserted.ID 
values(13);