19 lines
743 B
Markdown
19 lines
743 B
Markdown
# 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`
|