Is it possible for MS SQL to create a csv file in a folder with the results of a query on Windows server?

We have few very simple queries, I thought it would be very easy to have this saved in a local folder in windows, but I can’t seem to find the option to save the results in a file and schedule this to be done on a daily basis (overwriting the file). Can anyone help?

submitted by /u/_0x0_
[link] [comments]


Go to Source of this post
Author Of this post: /u/_0x0_
Title Of post: Is it possible for MS SQL to create a csv file in a folder with the results of a query on Windows server?
Author Link: {authorlink}