How to retrieve identity of inserted row (OLE DB)

I use CRowset::Insert() metod to insert a row. What should I do to retrieve value from its identity column? (I use Microsoft OLE DB Provider for SQL Server and SQL Server 7.0)

Hi,

After you've inserted nw record try this ( SQL Server only ):

Select @@IDENTITY from owner.table

I guess it will work.