# 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`