 复制USE SQL_Road GO CREATETABLE Employee ( UserID INT,篇学 ManagerID INT, Name NVARCHAR(10) ) INSERTINTO dbo.Employee SELECT 1,-1,NBoss UNIONALL SELECT 11,1,NA1 UNIONALL SELECT 12,1,NA2 UNIONALL SELECT 13,1,NA3 UNIONALL SELECT 111,11,NB1 UNIONALL SELECT 112,11,NB2 UNIONALL SELECT 121,12,NC1 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22. |