How to work with Microsoft SQL Server in Python?

You can connect, read, and insert data into an SQL database with just a few lines of Python code.

Microsoft SQL with Python:

pip install mssql-python

Code to connect to SQL Server:

import mssql_python

# Establish connection
# Specify connection string
connection_string = "YOUR_CONNECTION_STRING"
connection = mssql_python.connect(connection_string)

# Execute query
cursor = connection.cursor()
cursor.execute("SELECT * from customer")
rows = cursor.fetchall()

for row in rows:
    print(row)

# Close connection
connection.close()

👉 https://t.me/DataScience4 💋

This channels is for Programmers, Coders, Software Engineers.

0️⃣ Python
1️⃣ Data Science
2️⃣ Machine Learning
3️⃣ Data Visualization
4️⃣ Artificial Intelligence
5️⃣ Data Analysis
6️⃣ Statistics
7️⃣ Deep Learning
8️⃣ programming Languages

✅ https://t.me/addlist/8_rRW2scgfRhOTc0

✅ https://t.me/Codeprogrammer

This channels is for Programmers, Coders, Software Engineers.

0️⃣ Python
1️⃣ Data Science
2️⃣ Machine Learning
3️⃣ Data Visualization
4️⃣ Artificial Intelligence
5️⃣ Data Analysis
6️⃣ Statistics
7️⃣ Deep Learning
8️⃣ programming Languages

✅ https://t.me/addlist/8_rRW2scgfRhOTc0

✅ https://t.me/Codeprogrammer