>Is there any equivalent function (GETAUTOINCVALUE) to get the autoinc value in MS SQL SERVER ?
Yes, SCOPE_IDENTITY() function.
In SQL Server 2005 and up the best method would be to use OUTPUT clause of the INSERT command to get the new ID.
If it's not broken, fix it until it is.
My Blog 
