u010551520的博客

原始数据如下首先通过FOR XML PATH获取XML 元素字符串以XML格式输出查找结果SELECT ',' + new_name FROM new_test1Base FOR XML PATH ('')输出：,123,123,445,445,asdfSELECT ',' + new_name as m2 FROM new_test1Base ...

ROW_NUMBER可用于分页查询SELECT new_name, new_type, CreatedOn, ROW_NUMBER() OVER(ORDER BY CreatedOn) as new_number FROM new_test1Base ROW_NUMBER() OVER(PARTITION BY […])分组之后排序SELECT new_name, new_typ...