Text file in sql server

Question

I need to generate a text file. How do I go about it 🤷🏾‍♀️

Answer 1

Could you explain clearer what's the problem? Do you need to export table to text file?

Answer 2

In the icon bar at the top of the page in SQL Server Management Studio there are icons to select whether the query output is displayed in a grid, or in formatted text, or sent to a file.