摘要：select *,ROW_NUMBER() over(partition by paadmrowid order by OperateDate) as group_idx from His_AdmFirstPage where OperateDate between '2017-01-01' and 阅读全文

摘要：查询表中的数据，将数据转换成xml格式 select * from A for xml path 表中的数据转换成xml格式，value，name，ID <row> <ID>1 </ID> <NAME>张三 </NAME> <VALUE>aaa </VALUE> </row> <row> <ID>2 阅读全文