SQLSERVER 一个简单的CTE

 

;WITH T (A) AS (
    SELECT 'X' A
)
SELECT *  FROM T