Viewing the SPID and code of query that cause block on SQL server

Viewing the SPID and code of query that cause block on SQL server

SPID :

select distinct blocked from sysprocesses where blocked > 0

Code :

dbcc inputbuffer(Spid)

or

select * from sysprocesses where spid=spid_number