Using Temp Table in Functions

CREATE TABLE #t (id INT)

GO

INSERT INTO #t VALUES (1),(2),(3)

GO

CREATE SYNONYM tSynonym FOR #t

GO

CREATE FUNCTION fnSTempTbl ()

RETURNS TABLE

AS

RETURN

(

SELECT * FROM tSynonym

)

GO

SELECT * FROM  fnSTempTbl ()

GO