blocks|key|567261|text|尝试使用导出向导。在本例中，我选择了整个表，但您也可以很容易地指定一个查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|567262|​|567263|📷|atomic|offset|length|567264|567265|567266|567267|567268|567269|567270|567271|567272|567273|567274|(您也可以在此处指定查询)|567275|567276|567277|567278|567279|567280|567281|567282|567283|567284|567285|567286|567287|567288|567289|567290|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8f9121b726afc452eb20ff8463873222.jpeg|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/8d97aef65eff693e30ad277e07447169.jpeg|2|https://ask.qcloudimg.com/http-save/yehe-900000/c44fdbad9b30315c2d955dcb06950047.jpeg|3|https://ask.qcloudimg.com/http-save/yehe-900000/fbe4580d59efca37b709793b0e45bb7c.jpeg|4|https://ask.qcloudimg.com/http-save/yehe-900000/3e30ab00217959b44c791fa491797f6c.jpeg|5|https://ask.qcloudimg.com/http-save/yehe-900000/107c9a42eb553ccc21526b18a3be5cec.jpeg|6|https://ask.qcloudimg.com/http-save/yehe-900000/7fdea353617f7b447c98bcaca4613cf8.jpeg|7|https://ask.qcloudimg.com/http-save/yehe-900000/1f84da81482e4e6fead0c5b7d6b2074d.jpeg|8|https://ask.qcloudimg.com/http-save/yehe-900000/4216f2e3603cd1fcaa02d1a9089719e7.jpeg^0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|1|2|0|0|0|0|1|3|0|0|0|0|0|1|4|0|0|0|0|1|5|0|0|0|0|1|6|0|0|0|0|1|7|0|0|0|0|1|8|0|0^^$0|@$1|2|3|4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|20|8|@]|9|@$G|21|H|22|1|23]]|A|$]]|$1|I|3|C|5|6|7|24|8|@]|9|@]|A|$]]|$1|J|3|C|5|6|7|25|8|@]|9|@]|A|$]]|$1|K|3|E|5|F|7|26|8|@]|9|@$G|27|H|28|1|29]]|A|$]]|$1|L|3|C|5|6|7|2A|8|@]|9|@]|A|$]]|$1|M|3|C|5|6|7|2B|8|@]|9|@]|A|$]]|$1|N|3|E|5|F|7|2C|8|@]|9|@$G|2D|H|2E|1|2F]]|A|$]]|$1|O|3|C|5|6|7|2G|8|@]|9|@]|A|$]]|$1|P|3|C|5|6|7|2H|8|@]|9|@]|A|$]]|$1|Q|3|E|5|F|7|2I|8|@]|9|@$G|2J|H|2K|1|2L]]|A|$]]|$1|R|3|C|5|6|7|2M|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|2N|8|@]|9|@]|A|$]]|$1|U|3|C|5|6|7|2O|8|@]|9|@]|A|$]]|$1|V|3|E|5|F|7|2P|8|@]|9|@$G|2Q|H|2R|1|2S]]|A|$]]|$1|W|3|C|5|6|7|2T|8|@]|9|@]|A|$]]|$1|X|3|C|5|6|7|2U|8|@]|9|@]|A|$]]|$1|Y|3|E|5|F|7|2V|8|@]|9|@$G|2W|H|2X|1|2Y]]|A|$]]|$1|Z|3|C|5|6|7|2Z|8|@]|9|@]|A|$]]|$1|10|3|C|5|6|7|30|8|@]|9|@]|A|$]]|$1|11|3|E|5|F|7|31|8|@]|9|@$G|32|H|33|1|34]]|A|$]]|$1|12|3|C|5|6|7|35|8|@]|9|@]|A|$]]|$1|13|3|C|5|6|7|36|8|@]|9|@]|A|$]]|$1|14|3|E|5|F|7|37|8|@]|9|@$G|38|H|39|1|3A]]|A|$]]|$1|15|3|C|5|6|7|3B|8|@]|9|@]|A|$]]|$1|16|3|C|5|6|7|3C|8|@]|9|@]|A|$]]|$1|17|3|E|5|F|7|3D|8|@]|9|@$G|3E|H|3F|1|3G]]|A|$]]|$1|18|3|C|5|6|7|3H|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|3I|8|@]|9|@]|A|$]]]|1A|$1B|$5|1C|1D|1E|A|$1F|1G|1H|-4]]|1I|$5|1C|1D|1E|A|$1F|1J|1H|-4]]|1K|$5|1C|1D|1E|A|$1F|1L|1H|-4]]|1M|$5|1C|1D|1E|A|$1F|1N|1H|-4]]|1O|$5|1C|1D|1E|A|$1F|1P|1H|-4]]|1Q|$5|1C|1D|1E|A|$1F|1R|1H|-4]]|1S|$5|1C|1D|1E|A|$1F|1T|1H|-4]]|1U|$5|1C|1D|1E|A|$1F|1V|1H|-4]]|1W|$5|1C|1D|1E|A|$1F|1X|1H|-4]]]]

Try the Export Wizard. In this example I select a whole table, but you can just as easily specify a query:

<img src="https://i.stack.imgur.com/pD9oC.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/F6rz5.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/v0NZG.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/ELJbo.jpg" alt="enter image description here">

(you can also specify a query here)

<img src="https://i.stack.imgur.com/s5HPS.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/F5lLv.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/kHLF1.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/j98t7.jpg" alt="enter image description here">

<img src="https://i.stack.imgur.com/jLrCK.jpg" alt="enter image description here">

blocks|key|351411|text|另一种可能是使用剪贴板将结果直接复制并粘贴到Excel中。只需小心处理常规类型的Excel列，因为它们有时会产生不可预测的结果，具体取决于您的数据。在结果网格中的任意位置单击CTL-A，然后右键单击：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|351412|​|351413|📷|atomic|351414|351415|如果您在Excel的常规格式执行不需要的转换时遇到问题，请在粘贴之前在Excel中选择空白列，并将格式更改为“文本”。|351416|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/fe46be5e2ac0a75eccc8d28018a1032f.jpeg|imageAlt^0|2F|5|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|K|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|15|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|O|$P|$5|Q|R|S|E|$T|U|V|-4]]]]

Another possibility is to use the clipboard to copy and paste the results directly into Excel. Just be careful with General type Excel columns, as they can sometimes have unpredictable results, depending on your data. <code>CTL-A</code> anywhere in the result grid, and then right-click:

<img src="https://i.stack.imgur.com/6Mh7b.jpg" alt="enter image description here">

If you have trouble with Excel's General format doing undesired conversions, select the blank columns in Excel before you paste and change the format to "text".

blocks|key|567405|text|至少在SQL+Server+2012中，您可以在查询窗口中右键单击并选择查询选项。在那里，您可以选择包括网格和/或文本的标题，并让另存为按您希望的方式工作，而无需重新启动SSMS。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|567406|您仍然需要在菜单栏的Tools->Options中进行更改，才能让新的查询窗口默认使用这些设置。|567407|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

At least in SQL Server 2012, you can right click in the query window and select Query Options. From there you can select Include Headers for grid and/or text and have the Save As work the way you want it without restarting SSMS.

You'll still need to change it in Tools->Options in the menu bar to have new query windows use those settings by default.

blocks|key|351604|text|同样的问题也存在于Visual+Studio中，下面是如何修复它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351605|请转至：|351606|Tools+>+Options+>+SQL+Server+Tools+>+Transact-SQL+Editor+>+Query+Results+>+Results+To+Grid|code-block|syntax|javascript|351607|现在点击复选框为true："Include+column+headers+when+copying+or+saving+the+result“|351608|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The same problem exists in Visual Studio, here's how to fix it there:

Go to:

<pre><code>Tools &gt; Options &gt; SQL Server Tools &gt; Transact-SQL Editor &gt; Query Results &gt; Results To Grid
</code></pre>

Now click the check box to true: "Include column headers when copying or saving the results"

blocks|key|351555|text|点击左上角选择你的结果，右击并选择“复制标题”。粘贴到excel中。完成了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351556|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Select your results by clicking in the top left corner, right click and select "Copy with Headers".
Paste in excel.
Done!

blocks|key|351719|text|在SQL+Server+2014+Management+Studio中，该设置位于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351720|工具>选项>查询结果>+SQL+Server+>结果到文本>在结果集中包括列标题。|351721|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In SQL Server 2014 Management Studio the setting is at:

Tools > Options > Query Results > SQL Server > Results to Text > Include column headers in the result set.

blocks|key|351669|text|我也面临着同样的问题。当我使用时，在查询窗口中单击鼠标右键并选择查询选项。但是标题行不会显示在输出CSV文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351670|然后我注销服务器，再次登录并运行脚本。然后它就成功了。|351671|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I also face the same issue. When I used right click in the query window and select Query Options. But header rows does not show up in output CSV file. 

Then I logoff the server, login again and run the script. Then it worked.

I am using SQL Server Management Studio. 

I wish to save the results of a query to an excel file. 

I choose "save as" and then save to CSV file which I can open in excel. All good except I am missing column headers, any ideas how I get them exported?

Saving results with headers in Sql Server Management Studio

Visual Studio

SQL Server

服务器

我正在使用SQL Server Management Studio。我希望将查询结果保存到excel文件中。我选择“另存为”，然后保存到CSV文件，我可以在excel中打开。一切都很好，除了我缺少列标题，你知道我怎么把它们导出吗？

问在Sql Server Management Studio中保存包含标题的结果
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Sql Server Management Studio中保存包含标题的结果EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Sql Server Management Studio中保存包含标题的结果
EN