本文介绍了SQL Server:将查询导出为.txt文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将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文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!