Python Part 16a - Linking to SQL Server

By Andy Brown

Learn how to use connections and cursors to get rows of data from SQL Server databases from within Python, how to commit insert, update or delete statements and how to execute stored procedures, passing parameters.

Chapters
00:00 Topic list
01:17 A Pandas warning
02:21 Our example database
03:24 Connecting to SQL Server
08:25 Fetching rows
14:25 Running action queries
21:53 Running stored procedures

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

[montieeaster]

All these years and finally got to see who Andy is. My long lost big brother who taught me so many languages.

[wayneedmondson]

Thanks Andy! Great series. Hope I can spend more time on Python in the future. Thumbs up!!

[vigneshe]

Hi is there a formula to track outlook email in vba with between formula

[ellukayou]

I had a problem installing pyodbc on python 3.10, I resorted to a premature whl.