Code for Exporting Data:
SQLCMD -S DESKTOP-76IUJ1R -d TestDatabase -E -Q "select * from [tblDatabase] ORDER BY DatabaseCPU_Load" -s "," -o "C:\Users\Charlie\Documents\SQL Data\Database_Data%date:~10,4%%date:~4,2%%date:~7,2%.csv"

Code for Deleting Data
SQLCMD -S DESKTOP-76IUJ1R -d TestDatabase -E -Q "DELETE FROM [tblDatabase]"

свернуть