Question: how to export data from sql server to text file using query?
Answer: The server name that I used is: RON\SQLEXPRESS.
The database name is: TestDB.
The query is: “select * from TestDB. dbo. Person“
The Path to store the exported file\FileName. txt is: “C:\Users\Ron\Desktop\Export. txt”