Create a Batch File to Run Python Script
Run Batch File from Python
Generate Backup Files with Timestamps
Export SQL query results
Create the Matrix Effect
Execute a Command Prompt Command from Python
Create a Batch File Directly from Python
Database Tutorials
Oracle
Use Spool in Oracle to Export Query Results to CSV
Export Query Results to CSV in Oracle SQL Developer
Export Query Output to Excel in Oracle SQL Developer
SQL Server
Create a Database in SQL Server
Create a Table in SQL Server
Case Statement in SQL Server
Export Query Results to CSV in SQL Server
LEFT, RIGHT and SUBSTRING in SQL Server
Get the Data Type of Columns in SQL Server
Insert Records Into a Table in SQL Server
Delete Records from a Table in SQL Server
Update Table Records in SQL Server
LEFT JOIN in SQL Server
Max Value in SQL Server
Create a Temporary Table in SQL Server
Join Tables from Different Databases in SQL Server