在SQL SERVER 2012中将SQL Server结果导出为Excel文件格式 [英] Export SQL Server result to Excel file format in SQL SERVER 2012

问题描述

您好我的所有方案是将我的商店程序导出数据导出为Excel文件格式，而无需手动创建列名和Excel文件。执行存储过程后，只需在D：\\中创建excel文件列应该与存储过程的结果集相同。一切只能从SQL SERVER 2012完成。



在此先感谢： - ）

解决方案

您好，请参阅链接 https://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/ [<一个href =https://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/\"target =_ blanktitle =New Window> ^ ]

Hi all my scenario is about exporting my store procedure resulting data to Excel file format without manually creating column name and excel file.After execution of the store procedure only the excel file has to be created in D:\\ and columns should as same as the result set from store procedure.Everything should be done only from SQL SERVER 2012.

Thanks in Advance :-)

解决方案

Hi, Please refer to the link https://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/[^]

这篇关于在SQL SERVER 2012中将SQL Server结果导出为Excel文件格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！