Database

1. Wrong; a table-valued function[^] may return more than one value as part of a result-set;
    
2. Correct; functions may not have OUTPUT parameters;
    
3. Wrong; a multi-statement UDF may contain[^]:
   
   • assignment statements;
   • control-of-flow statements (except TRY...CATCH);
   • DECLARE statements;
   • SELECT statements;
   • cursor operations referencing local cursors;
   • INSERT, UPDATE and DELETE statements modifying local table variables; and
   • EXECUTE statements calling extended stored procedures[^];
   
    
4. Sort-of; a function may call an extended stored procedure[^], but not a regular stored procedure;
    
5. Correct; a function may not contain a TRY...CATCH block;

The following statements are valid in a function: ... EXECUTE statements calling extended stored procedures.

Richard Deeming wrote:

Almost - I had to look a couple up to confirm what I thought.

Richard Deeming wrote:

Why would you disagree with #4 when it's documented in BOL[^]?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]