>>>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.
>
>Is is possible to pass this function together with the insert command in the SP , or I have to create a store procudure to call it ?
Yes, see my other reply, though I prefer using stored procedures.
If it's not broken, fix it until it is.
My Blog