我外面要傳進來一個引數,判斷它是否存在于遞回查出的資料中
WITH TEMP AS
(
SELECT * FROM Document_FileType WHERE Id = 18
UNION ALL
SELECT A.* FROM Document_FileType A JOIN TEMP ON A.ParentId = TEMP.Id
)
SELECT * FROM TEMP WHERE Id <> 18
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/121401.html
標籤:基礎類
上一篇:求stc15單片機程式
