Automatically Export Data from SQL Database to CSV Excel File and Delete Table Automatically

Published: 14 October 2023
on channel: Charlie Cabreros

11,210

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]"

Watch video Automatically Export Data from SQL Database to CSV Excel File and Delete Table Automatically online without registration, duration hours minute second in high quality. This video was added by user Charlie Cabreros 14 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,210 once and liked it 83 people.