sql server APPLY使用

SELECT a.*, b.s
FROM a
OUTER APPLY (select FNC_GET_YM(a.NO) s) AS b

这个是单个返回值，要select，还要别名

CREATE or replace FUNCTION dbo.GetOrderCount(@UserID INT)
RETURNS TABLE
AS
RETURN 
(
    SELECT COUNT(*) AS OrderCount
    FROM Table2
    WHERE UserID = @UserID
    GROUP BY UserID
)

SELECT t1.UserID, t1.UserName, t2.OrderCount
FROM Table1 t1
OUTER APPLY dbo.GetOrderCount(t1.UserID) t2

这个是table返回值，直接用