now when tried to test the command given by you, I ran the same quires mentione by me in my first post and it come out on its own with following message
(1 row(s) affected)
Msg 1205, Level 13, State 51, Line 5
Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Surprising. Why it did not happen when i tried first few times?