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

No video

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

Рет қаралды 10,118

Күн бұрын

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

Пікірлер: 12

@spk7054 3 ай бұрын

you are no.1 thank you nice video training

@shibinabraham7819 7 ай бұрын

Very nice and very useful video. absolutely handy for every day tasks. Can you make a video on how to schedule the same task using SQL agent. Consider a scenario you have 30 data sets to be created. This means, you will need 30 SQL jobs to run each of these batch files, in case any of the jobs aren't working, easy to figure out the error and trouble shoot. Ideally, I am thinking to implement this for data visualization project in Qlik View, where these files (.csv) files will be imported as data sources into Qlik View and then that will be scheduled to get the real time (on an hourly basis).

@mosesakwagiobe4438 5 ай бұрын

very clear and straightforward although mine is not generating the file

@jedwards543 Ай бұрын

Thank you! How can I do it to execute it with another user that I login to the SQL server using SQL server credentials?

@vanminhtrip 4 ай бұрын

Thank y my Professor ❤❤❤

@charliecabreros8158 4 ай бұрын

Any time

@luisverastegui4311 2 ай бұрын

I have a question, I compiled but I only see the black window for a few seconds and then nothing, the Excel was not created. Help please

@ismailbeijermany1977 4 ай бұрын

Ur name Schuld be professor thanks you very much

@djsash9402 3 ай бұрын

Hi Charlie. Good evening. I am in these field of coding… Can you please help me in converting my Safari History.db to .csv, 'where the links can be ordered by the date accessed' ? Thanks in advance.

@KarinS-tk3qt 3 ай бұрын

it gives me this error: " Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user " what should i do?

@VyshnaviiM 4 ай бұрын

Hi how to export data from sql stored procedure to Excel with same steps that u have used in the video please help me

@VyshnaviiM 4 ай бұрын

Actually im try to export data with 3 tables by joining them and some where conditions … im having issue so i wanted to convert to stored procedure and wanted to pull as per above ask