SQL 指令WITH * AS //// (CTE)

form http://www.cnblogs.com/CareySon/archive/2011/12/12/2284740.html

利用快取 儲存一個 "常用" 的查詢結果




WITH
cr AS
(
    select * from user WHERE Name like 'C%'
)
SELECT Name from cr WHERE Name like '%A%'