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