Create Procedure myProc
(pField1 [varchar](50),.. etc., nIdent [int] OUTPUT)
As
Insert Into myDb.dbo.myTbl Values (pField1,.. etc.)
Set nIdent=@@IDENTITY
Although I don't know how you would call this from an RV (or if you can use it). I've only used SPT and ADO for this type of calls.