blocks|key|1208344|text|您可以使用PowerShell|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1208345|$AttachmentPath+=+"CV+File+location"
$QueryFmt=+"Query"

Invoke-Sqlcmd+-ServerInstance+Server+-Database+DBName+-Query+$QueryFmt+%7C+Export-CSV+$AttachmentPath|code-block|syntax|javascript|1208346|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use PowerShell

<pre><code>$AttachmentPath = "CV File location"
$QueryFmt= "Query"

Invoke-Sqlcmd -ServerInstance Server -Database DBName -Query $QueryFmt | Export-CSV $AttachmentPath
</code></pre>

blocks|key|994178|text|MS+Excel+->+Data+->+New+Query+->+..follow+..follow的步骤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994179|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|$]]

MS Excel -> Data -> New Query -> From Database ..follow the steps

blocks|key|1208404|text|如果您的值包含逗号，则使用原生SQL+Server+Management+Studio技术导出到CSV+(如@8kb建议的)不起作用，因为SSMS不会将值括在双引号中。对于我来说，一种更健壮的方法是简单地复制结果(在网格内部单击，然后按CTRL-A、CTRL-C)，并将其粘贴到Excel中。然后从Excel保存为CSV文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1208405|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|$]]

Using the native SQL Server Management Studio technique to export to CSV (as @8kb suggested) doesn't work if your values contain commas, because SSMS doesn't wrap values in double quotes. A more robust way that worked for me is to simply copy the results (click inside the grid and then CTRL-A, CTRL-C) and paste it into Excel. Then save as CSV file from Excel.

blocks|key|993912|text|您可以使用QueryToDoc+(http://www.querytodoc.com)。它允许您针对SQL数据库编写查询，并在选择分隔符之后将结果导出到Excel、Word、HTML或CSV|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|993913|entityMap|0|LINK|mutability|MUTABLE|url|http://www.querytodoc.com/^0|H|P|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You could use QueryToDoc (<a href="http://www.querytodoc.com" rel="nofollow">http://www.querytodoc.com</a>). It lets you write a query against a SQL database and export the results - after you pick the delimiter - to Excel, Word, HTML, or CSV

blocks|key|994135|text|INSERT+INTO+OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=D:\;HDR=YES;FMT=Delimited','SELECT+*+FROM+[FileName.csv]')
SELECT+Field1,+Field2,+Field3+FROM+DatabaseName|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994136|正如@Slogmeister+Extraordinaire所引用的是正确的。|unstyled|994137|需要具有已存在列的1>文件，还需要安装2>|994138|面临的错误|994139|1|994140|消息7303，级别16，状态1，第1行无法初始化链接服务器“(Null)”的OLE+DB访问接口"Microsoft.ACE.OLEDB.12.0“的数据源对象。|994141|64位http://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine_x64.exe|offset|length|994142|32位http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe|994143|2|994144|消息15281，级别16，状态1，第1行SQL+server阻止了对组件“”即席分布式查询“”的语句“”OpenRowset/OpenDatasource“”的访问，因为此组件作为此服务器的安全配置的一部分已关闭。“系统管理员可以通过使用sp_configure启用“即席分布式查询”。有关启用“即席分布式查询”的详细信息，请在SQL+Server联机丛书中搜索“即席分布式查询”。|994145|EXEC+sp_configure+'show+advanced+options',+1
RECONFIGURE
GO
EXEC+sp_configure+'ad+hoc+distributed+queries',+0
RECONFIGURE
GO|994146|entityMap|0|LINK|mutability|MUTABLE|url|http://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine_x64.exe|http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe^0|0|0|0|0|0|0|3|32|0|0|3|2Y|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|1B|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|1C|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1D|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1E|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1F|8|@]|9|@$Q|1G|R|1H|1|1I]]|A|$]]|$1|S|3|T|5|F|7|1J|8|@]|9|@$Q|1K|R|1L|1|1M]]|A|$]]|$1|U|3|V|5|F|7|1N|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1O|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1P|8|@]|9|@]|A|$B|C]]|$1|10|3|-4|5|F|7|1Q|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]|L|$5|13|14|15|A|$16|18]]]]

<pre><code>INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=D:\;HDR=YES;FMT=Delimited','SELECT * FROM [FileName.csv]')
SELECT Field1, Field2, Field3 FROM DatabaseName
</code></pre>
as @Slogmeister Extraordinaire Quoted is correct.
One need to have
1&gt; File already present with columns
2&gt; One need to have Office installed
Errors faced
<h1>1</h1>
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider &quot;Microsoft.ACE.OLEDB.12.0&quot; for linked server &quot;(null)&quot;.&quot;
64 bit
<a href="http://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine_x64.exe" rel="nofollow noreferrer">http://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine_x64.exe</a>
32 bit
<a href="http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe" rel="nofollow noreferrer">http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe</a>
<h1>2</h1>
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', search for 'Ad Hoc Distributed Queries' in SQL Server Books Online.
<pre><code>EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 0
RECONFIGURE
GO
</code></pre>

blocks|key|994204|text|这里还有一个值得一提的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994205|SQLCMD+-S+SEVERNAME+-E+-Q+"SELECT+COLUMN+FROM+TABLE"+-s+","+-o+"c:\test.csv"|code-block|syntax|javascript|994206|注意:我没有看到任何网络管理员让您运行powershell脚本|994207|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

One more method worth to mention here:
<pre><code>SQLCMD -S SEVERNAME -E -Q &quot;SELECT COLUMN FROM TABLE&quot; -s &quot;,&quot; -o &quot;c:\test.csv&quot;
</code></pre>
NOTE: I don't see any network admin let you run powershell scripts

blocks|key|1208617|text|我希望10年不会太晚，我在Windows+Scheduler中使用了这个；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1208618|"C:\Program+Files\Microsoft+SQL+Server\110\Tools\Binn\SQLCMD.EXE"
-S+BLRREPSRVR\SQLEXPRESS+-d+Reporting_DB+-o+"C:\Reports\CHP_Gen.csv"+-Q+"EXEC+dbo.CHP_Generation_Report"+-W+-w+999+-s+","|code-block|syntax|javascript|1208619|它打开sql命令.exe并运行为sql命令设计的脚本。sql命令脚本非常容易使用，只需进行几次google搜索和反复试验即可。您可以看到，它选择了一个数据库，定义了输出位置并执行了一个过程。该过程只是从数据库中的表中选择要显示的行和列的查询。|1208620|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I hope 10 years isn't too late, I used this in Windows Scheduler;
<pre><code>&quot;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE&quot;
-S BLRREPSRVR\SQLEXPRESS -d Reporting_DB -o &quot;C:\Reports\CHP_Gen.csv&quot; -Q &quot;EXEC dbo.CHP_Generation_Report&quot; -W -w 999 -s &quot;,&quot;
</code></pre>
It opens sql command .exe and runs a script designed for sql command. The sql command script is very easy to use with a few google searches and trial and error. You can see that it picks a database, defines output location and executes a procedure. The procedure is just a query selecting which rows and columns to display from a table in the database.

How can I export a query result to a .csv file in SQL Server 2008?

Export query result to .csv file in SQL Server 2008

SQL数据库

SQL Server

数据库

服务器

Windows

如何在SQL Server2008中将查询结果导出为.csv文件？

问将查询结果导出到SQL Server2008中的.csv文件
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将查询结果导出到SQL Server2008中的.csv文件EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将查询结果导出到SQL Server2008中的.csv文件
EN