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”