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.


Комментарии

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

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

Data Table Filters within Charts in Power BI

Изображение
To show underlying data for a chart visualization in Power BI, follow these steps: Select the chart visual that you want to view the underlying data for. Click on the "ellipses" (...) at the top right corner of the visual to open the dropdown menu. From the dropdown menu, select "Show as a table" option. Power BI will then display a table with the underlying data for the chart visual. You can scroll through the table to view all the data. If you want to export the underlying data to a CSV or Excel file, click on the "Export data" button at the top right corner of the table. If  you need to show background data related to some point at the chart, use "Show data point as a table" from chart figure context menu. The underlying data depends on selected Legend data field columns and source data table cannot be created by selecting several records from a chart.
Далее...

Beneficiaries and Disiribution database

Изображение
<?xml version="1.0" encoding="utf-8" ?> <!-- SQL XML created by WWW SQL Designer, https://github.com/ondras/wwwsqldesigner/ --> <!-- Active URL: https://sql.toad.cz/?keyword=default --> <sql> <datatypes db="mssql"> <group label="Integer" color="rgb(238,238,170)"> <type label="TinyInt" length="0" sql="tinyint" re="INT" quote="" bytes="1" note="Integer data: 0 to 255"/> <type label="SmallInt" length="0" sql="smallint" re="INT" quote="" bytes="2" note="Integer data: -32,768 to 32,767"/> <type label="Int" length="0" sql="int" re="INT" quote="" bytes="4" note="Integer data: -2,147,483,648 to 2,147,483,647"/> <type label="BigInt" length="0" sql=...
Далее...