摘要:
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 阅读全文