SQL Server Management Studio 中是否有 SELECT ... INTO OUTFILE 等效项? [英] Is there a SELECT ... INTO OUTFILE equivalent in SQL Server Management Studio?

问题描述

MySQL 有一个漂亮的命令 SELECT ... INTO OUTFILE 可以将结果集写入文件(CSV 格式或其他一些可选格式).

MySQL had a nifty command SELECT ... INTO OUTFILE that could write the result set into a file (CSV format or some other optional format).

我目前正在使用 SQL Server Management Studio 查询 MS-SQL 后端服务器.我有多个 SQL 查询，想将输出结果集写入文件.有什么办法可以将查询的结果直接存储到文件中吗?

I am currently using SQL Server Management Studio to query an MS-SQL backend server. I have multiple SQL queries and would like to write the output result set into a file. Is there any way I could store the results from a query directly into a file?

推荐答案

在 SSMS 中，查询"菜单项...结果到"...结果到文件"

In SSMS, "Query" menu item... "Results to"... "Results to File"

快捷键 = CTRL+shift+F

Shortcut = CTRL+shift+F

你也可以全局设置

工具"...选项"...查询结果"...SQL Server"...默认目标"下拉菜单

"Tools"... "Options"... "Query Results"... "SQL Server".. "Default destination" drop down

评论后

在SSMS中，查询"菜单项...SQLCMD"模式

In SSMS, "Query" menu item... "SQLCMD" mode

这允许您像操作一样运行命令行".

This allows you to run "command line" like actions.

在我的 SSMS 2008 中进行快速测试

A quick test in my SSMS 2008

:OUT c:\foo.txt
SELECT * FROM sys.objects

编辑，2012 年 9 月

Edit, Sep 2012

:OUT c:\foo.txt
SET NOCOUNT ON;SELECT * FROM sys.objects

这篇关于SQL Server Management Studio 中是否有 SELECT ... INTO OUTFILE 等效项?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！