Cacher is the code snippet organizer for pro developers

declare @sid int = 52

select TEXT
from sys.dm_exec_connections
cross apply sys.dm_exec_sql_text(most_recent_sql_handle)
where session_id = @sid