not sure what you mean...inside a TSQL code block, you could use
print object_name(@@PROCID)
or do you mean show me all the sql statements that are currently running on the server, like from one of the DMV's?
SELECT DEST.TEXT
FROM sys.[dm_exec_connections] SDEC
CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST
--WHERE SDEC.[most_recent_session_id] = @spid
Lowell