Quiz: Multi-Statement Table Valued Functions

Quiz: Multi-Statement Table Valued Functions

Want to study before you take the quiz? Read 'Introducing Interleaved Execution for Multi-Statement Table Valued Functions' by Joe Sack. For the syntax questions, the Microsoft reference for CREATE FUNCTION is here.
  • CREATE FUNCTION [schema].[function_name]
        (@parameter_name AS INT)
    RETURNS @return_variable TABLE 
    AS
    BEGIN
        RETURN 
    END
  • CREATE FUNCTION [schema].[function_name]
        (@parameter_name AS INT)
    RETURNS TABLE
    AS
    RETURN (  )
    

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.