SQL：创建临时表的csv文件，然后在同一个csv中修改新值 [英] SQL :Creating a csv file of a temp table and then later Amending new values in the same csv

问题描述

大家好，



我正面临问题。我有一个存储过程，它返回一个临时表。我必须创建输出临时表的csv文件

但是我必须在同一个csv文件中为temp表的新值修改值，同时一次又一次地运行相同的过程





请帮帮我同样的

Hi all,

I am facing issue. I have a Stored Procedure which return me a temp table. i have to create csv file of the output temp table
but the catch is I have to Amend the values in the same csv file for the new values of the temp table while running the same procedure again and again


Please help me for the same

推荐答案

看看这里： http：// stackoverflow。 com / questions / 425379 / how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd [ ^ ] with sqlcmd选项 [ ^ ]。



教程 - 一步一步：http://www.sqlservercurry.com/2011/01/sql-server-export-table-to-csv.html [使用bcp命令：

https://www.simple-talk.com/sql/database-administration/creating-csv-files-using -bcp-and-stored-procedures / [ ^ ]



有趣的CP文章：

简化的SQL-CSV导入/导出功能 [ ^ ]

Have a look here: http://stackoverflow.com/questions/425379/how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd[^] with sqlcmd options[^].

Tutorial - step by step: http://www.sqlservercurry.com/2011/01/sql-server-export-table-to-csv.html[^]

Using bcp command:
https://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/[^]

Interesting CP article:
A Simplified SQL-CSV Import/Export Functionality[^]

这篇关于SQL：创建临时表的csv文件，然后在同一个csv中修改新值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！