Question: how to export data to text file in sql server?
Answer: If you want to save the results in a txt file, you can do this in SSMS. Go to Tools>Options:
Select the option Result to file:
Create a query and execute the query. ... 
The result saved are the following:
SQLCMD. ... 
PowerShell. ... 
Import/Export Wizard in SSMS. ... 
You will open the SQL Server Import and Export wizard: