How to make a batch file to select from a SQL database in txt?

Question

cmd/bat

Good afternoon, tell me how you can run a SQL script through a batch file so that the results of the selection get into a text file?

Answer 1

osql -S [Server] -E -Q "SELECT * FROM [Database].dbo.[Table]" > text