Yes It actually worked for me now. My table has no index. First I ran the below statement in one query window

BEGIN TRAN

update dbo.Profit_Act1 with(rowlock)

--rowlock is the default lock level

set France = 24000

where ID=2

Then I opened another query window and ran the below statement

BEGIN TRAN

update dbo.Profit_Act1 with(rowlock)

--rowlock is the default lock level

set France = 22000

where ID=1

The first one ran but the second didnt since I had not commited the tran on my query window

Then i commited them and added index to the table. Then I recreated the same scenario but at this time the query in my second window ran without any problems

Also the execution plan clearly showed the table scan missing after adding the index