I m trying to do that

I want to be sure

BEGIN TRANSACTION

SELECT * FROM SomeRecords where id=1

............

Some Select and if statment

..........

UPDATE SomeRecords set=somerow where id=1

UPDATE SomeRecords

COMMIT TRAN

I have to sure while the commit transaction no body change my records i m trying to lock that records