python-mssql-interaction
Demo project showing how to interact with SQL Server from Python using pyodbc.
Structure
| Folder | Purpose |
|---|---|
basic-sql-server-interactions-and-dml/ |
Connecting, running queries, and CRUD operations (INSERT, UPDATE, DELETE, SELECT) with and without parameters |
stored-procedures/ |
Creating and calling stored procedures with and without output parameters |
functions/ |
Creating and calling user-defined functions and built-in system functions |
advanced-topics/ |
Bulk inserts from CSV, executing .sql scripts via PowerShell, CSV-to-table inserts, and a basic Tkinter TUI |
Requirements
- Python 3.13+
- SQL Server with ODBC Driver 17
pip install -r requirements.txt