摘要:
;WITH CTE AS (SELECT [RGTCID] ,ltrim(rtrim(T.N.value('.','varchar(100)'))) as Querystr FROM [R_GT_Collection] cross apply RGTCData.nodes('//*[@data-type="Collection"]/@Query') T(N) where N.value('../@data-from','varchar(100)') is null),CollectionIDs 阅读全文