更新时间:2023-02-07 11:33:41
为什么选择Excel数据透视表?我建议你使用SQL Pivots:
参见这些文章:
演练:基于SQL Server数据在Excel中创建图表 [ ^ ] - 我最喜欢的;)
如何使用T-SQL PIVOT数据 [ ^ ]
使用PIVOT和UNPIVOT [ ^ ]
请参阅以下问题:如何将数据从SQL SERVER导出到Excel [ ^ ]
Why Excel pivot table? I would suggest you to use SQL Pivots:
See these articles:
Walkthrough: Creating a Chart in Excel Based on SQL Server Data[^] -my favorite ;)
How to PIVOT Data Using T-SQL[^]
Using PIVOT and UNPIVOT[^]
See questions about: How to export data from SQL SERVER to Excel[^]