title: Adding Execute (@query) in function error 'incorrect syntax near execute
body: <p>I want to create a function in SQL Server 2005 that returns a table which the query is passing from my program...</p>
  
  <p>But when I create that function with this script: </p>
  
  <pre><code>CREATE FUNCTION fn_test (@source varchar(255))  
  RETURNS TABLE AS  
  RETURN
      EXECUTE (@source)
  </code></pre>
  
  <p>The script is showing error message </p>
  
  <blockquote>
    <p><em>Incorrect syntax near the keyword "EXECUTE`</em></p>
  </blockquote>