Day 4. SQL Server interraction with pyodbc

In this video we'll find out how to get connection string for Python ODBC connection in three ways: manual, with SSMS and using online generators. Also, the speaker talks about query executing and committing at examples SELECT and INSERT queries.


Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Today's activity report #17

Изображение
Today I re-cleaned the primary data for the second round of the survey. Reduced the number of pseudo-unique names and patronymics. Converted respondents' dates of birth from text to date and verified their correctness. Found about 80 errors (for example, people born in 2023 and 2064). In the part of names, when entering, the Latin letter 'i' was used instead of the Ukrainian one. In addition, I found 9 cases of missing names or patronymics (surname or first name written twice) Time spent: 4h
Далее...