DECLARE@test_dbccTABLE(表编号VARCHAR(50),父级GIDVARCHAR(50));WITHDEPT_TREEAS(SELECT表编号,父级GIDFROM[资源_科目表]WHERE父级GID=@表编号UNIONALLSELECTd.表编号,d.父级GIDFROM...
DECLARE @test_dbcc TABLE ( 表编号 VARCHAR(50) , 父级GID VARCHAR(50) ); WITH DEPT_TREE AS ( SELECT 表编号 , 父级GID FROM [资源_科目表] WHERE 父级GID = @表编号 UNION ALL SELECT d.表编号 , d.父级GID FROM [资源_科目表] D JOIN DEPT_TREE H ON D.父级GID = H.表编号 ) INSERT INTO @test_dbcc SELECT * FROM DEPT_TREE 我应该在mysql里怎么写?最好写详细点,用临时表写完结果不对
展开