Even i get the result reflecting with new value before the commit tran is issued.

I had ran all the select & update with same SID.

Also, if th above doesnt make any sense. DO i need to recycle my sql sever instance to take effect. ?????