I'm developing a simple DataBase application which only function is to display
data, and depending on user interaction it [the application] has to insert
some values in a Table, And I need the Identity of those records.

In SQL I simply add this "return @@identity" to the SQL insertion code. The
point is that due to some requirements on DB this Sql sentences can't be
store-procedures (yes, all sql sentences are on the VB app it self). And,
so far, all solutions I've found on the net, to get that value, works for
What do I do?

Thanks a lot,