CREATE FUNCTION f_cid(@id int)
RETURNS TABLE
AS
RETURN(
SELECT [id],1 FROM [tb]
WHERE [pid]=@id
UNION ALL
SELECT A.[id],B.[level]+1
FROM [tb] A,ctb B
WHERE A.[pid]=B.[id]
)
GO
RETURNS TABLE
AS
RETURN(
SELECT [id],1 FROM [tb]
WHERE [pid]=@id
UNION ALL
SELECT A.[id],B.[level]+1
FROM [tb] A,ctb B
WHERE A.[pid]=B.[id]
)
GO
是个临时表,不应该去掉
对象名 'ctb' 无效。