SQL Server:将查询导出为.txt文件 [英] SQL Server : export query as a .txt file

问题描述

我正在尝试将SQL Server查询结果导出到.txt格式的文件夹中(这是针对自动化作业的)

I am trying to export my SQL Server query results into a folder in .txt format (this is for an automated job)

我知道MySQL中的等效项可以与INTO OUTFILE一起使用.有谁知道在SQL Server 2008 Management Studio中执行此操作的最佳方法?

I know the equivalent in MySQL works with INTO OUTFILE. Does anyone know the best way to do this in SQL Server 2008 Management Studio?

SELECT DISTINCT RTRIM (s1.SGMNTID) AS 'AccCode',RTRIM (s1.DSCRIPTN) AS 'CodeDesc', CASE
    WHEN  s1.SGMTNUMB = '1' THEN '1' 
    WHEN s1.SGMTNUMB = '2' THEN '2'
    WHEN s1.SGMTNUMB = '3' THEN '110'
    WHEN s1.SGMTNUMB = '4' THEN '4'
    WHEN s1.SGMTNUMB = '5' THEN '120'
    END AS 'AccountType_id',
CASE WHEN s1.SGMTNUMB = '2' 
THEN LEFT(s1.SGMNTID, 2)
ELSE 'DEFAULT'
END AS 'AccGroupName'

 FROM GL40200 s1

UNION 

SELECT  REPLACE ([ACTNUMBR_1]+'-'+ [ACTNUMBR_2]+'-'+ [ACTNUMBR_3]+'-'+[ACTNUMBR_4]+'-'+    [ACTNUMBR_5],' ', '') AS 'AccCode',
 '' AS 'CodeDesc',
 '0' AS 'AccountType_id',
 'Default' AS 'AccGroupName'
FROM GL00100 a

INTO OUTFILE 'C:\Users\srahmani\verian/myfilename.txt'

推荐答案

您可以在SSMS应用程序(而不是SQL)中执行此操作.在工具栏中选择

you do this in the SSMS app, not the SQL. In the toolbar select

查询->结果到->结果到文件

Query --> Results To --> Results To File

这篇关于SQL Server:将查询导出为.txt文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！