Can T-SQL function return user-defined table type?

问题:

This question already has an answer here:

• SQL Server 2008: Can a multi-statement UDF return a UDT? [duplicate] 1 answer
• SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function? 5 answers

I have my own type:

CREATE TYPE MyType AS TABLE
(
    foo INT
)

and a function receiving it as a parameter:

CREATE FUNCTION Test
(
    @in MyType READONLY
)
RETURNS @return MyType
AS
...

can it return MyType or only TABLE repeating MyType's structure:

CREATE FUNCTION Test
(
    @in MyType READONLY
)
RETURNS @return TABLE (foo INT)
AS
...

?

回答1:

As far as I understand Microsoft's MSDN article here, those user-defined table types are only available as read-only parameters to stored procedures or stored functions.

It doesn't mention anything that they could be used to be returned from a user-defined function, unfortunately - so I guess you're right - it's not possible (at least not now).