why deadlock occurs in sql server code example

Example: t sql check active deadlock

select * from sys.sysprocesses where blocked > 0