gistfile1.txt

CREATE FUNCTION dbo.InlineTVF
(
    @advisorId char(5)
)
RETURNS TABLE
RETURN
    SELECT 100 AS demo
GO
CREATE FUNCTION dbo.MultilineTVF
(
    @advisorId char(5)
)
RETURNS TABLE
    @ReturnTable TABLE
    (
        demo int
    )
AS
BEGIN
    INSERT INTO @ReturnTable
    SELECT 100 AS demo
    RETURN
GO