title: How does sys.dm_exec_sql_text work?
body: <p>Can you please explain why </p>
  
  <p><code>select * from sys.dm_exec_sql_text (sql_handle)</code>
  throws an error (Invalid column name 'sql_handle'), but</p>
  
  <p><code>select * from sys.sysprocesses cross apply sys.dm_exec_sql_text (sql_handle)</code> is a valid query?
  Thank you.</p>