>Is there any equivalent function (GETAUTOINCVALUE) to get the autoinc value in MS SQL SERVER ?
Yes, see SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in BOL.
The SCOPE_IDENTITY() usually works the best unless you have some special requirements.
--sb--