Practice T-SQL common table expression (CTE)
Data query (Part 1)
1. Use CTE for basic query
/****** Query data sets with root properties******/
WITH CTE ([AIID], [ThisGUID], [ParentGUID], [Information], [Version], [Reserved]
) AS (
SELECT [AIID], [ThisGUID], [ParentGUID], [Information], [Version], [Reserved]
FROM tTreeList
WHERE 1 = 1
AND 0 < LEN([Information ...
Added by ferronrsmith on Wed, 26 Jan 2022 16:16:56 +0200