DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52
SELECT * FROM ::fn_get_sql(@Handle)

SELECT * FROM sys.sysprocesses s CROSS APPLY fn_get_sql(sql_handle)