what is the facility SQLServer 8.00.194 give with its ROWLOCK feature.

How we can implement the record locking facility with VB and SQLServer?
i'll be pleased if u people suggest a method wih example.

thanks in advance

Noble C.Koroth