Generate file from sql

Anu

2y1.1kSQL

Hi,

I have a table with some data in my sql database. I want to print the result of that table in to a file in my system from sql . I found some ways to print text from sql to a text format file. My requirement is to send the sql command output into a text file.Please suggest a way to solve my problem.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naveen Kumar2y ago

If you are OK to use xp_cmdshell, then try below query.

EXEC xp_cmdshell 'bcp [database].[schema].[table] out "C:\Test\TableToFile.txt" -c -T'

Ensure your server have configured to run xp_xmdshell, if not run the below query to configure it.

Use Master
GO

EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO

EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE WITH OVERRIDE
GO

Sachin Singh2y ago
You can use the command Promt
```
sqlcmd -i c:\sql\myquery.sql -o c:\sql\myoutput.txt
```
where c:\sql\myquery.sql is the path of the SQL query file.
Anu2y ago
Hi,

I tried the way which you suggested, but getting below error
Jithu Thomas2y ago
In SQL Server the bcp utility for exporting query results to a text file. You can execute it from SQL Server Management Studio or a command prompt. Here's an example:

bcp "SELECT column1, column2 FROM your_table" queryout "C:\path\to\your\file.txt" -c -T

Replace column1, column2 with the columns you want to export, C:\path\to\your\file.txt with the path to your output file, and your_table with the name of your table.