WITH TestCTE (ID
,Name
,ParentId
,Level)
AS
(
SELECT ID
,Name
,ParentId
,0 Level
FROM dbo.MyFirends F1P
UNION ALL
SELECT F.ID
,F.Name
,F.ParentId
,Level - 1
FROM dbo.MyFirends F
INNER JOIN TestCTE CTE ON F.ID = CTE.ParentId
)
select ID
,Name
,ParentId
,-1*Level
from TestCTE C
Introduction to ASP.NET Identity - ASP.NET 4.x
-
The ASP.NET membership system was introduced with ASP.NET 2.0 back in 2005,
and since then there have been many changes in the ways web applications
typica...
10 months ago
No comments:
Post a Comment