To further what TG is saying...

Although it might be an effort to "retrieve" the IDENTITY VALUE used by an INSERT - that is the way you are supposed to do it.

If you are making your own values to get around the effort required to retrieve the value SQL uses - then reconsider what you are doing.