How to create a tab-delimited txt file?

Question

I want to use SQL SERVER 2005 commands to create a tab delimited file. I want to create a complex query and pass it (for example, a function) to export data with column names to a tab delimited file.

If you don't know what this does, suggest an idea that reduces headaches by doing this from scratch using C #.

AHH, I don’t want to learn SSRS, because I have to finish it in one day, but if this is the only way, tell me.

Thanks for ur time

Answer 1

try the SQL Server bcp.exe tool

Answer 2

, . , SQL Server Management Studio.

Tools -> Options -> Query Results -> SQL Server -> Results to Text "Tab delimited". , , SSMS, , " " (Query -> Results To -> Results to Text). , .

.

, , .