SQL Server 建立回傳暫存表結果的資料表值函數

建立內嵌資料表值函數，執行多條陳述式並回傳查詢結果：

SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE FUNCTION csj_csj(@id AS INT)
RETURNS @temp TABLE (
    [id] INT,
    [zd] VARCHAR(100),
    [xl] VARCHAR(100)
)
AS
BEGIN
    INSERT INTO @temp
    SELECT id, zd, xl FROM deb;  -- 確保欄位一致
    RETURN;  -- 必須有 RETURN
END;
GO

呼叫方式：`SELECT * FROM csj_csj(1);`