Sql break in ssn databases with room to edit for your choice
import pyodbc
# Establish a connection
conn = pyodbc.connect(
'DRIVER={SQL Server};'
'SERVER=your_server;'
'DATABASE=your_database;'
'UID=your_username;'
'PWD=your_password'
)
# Create a cursor object
cursor = conn.cursor()
# Execute a query
cursor.execute("SELECT @@VERSION")
# Fetch and print the result
data = cursor.fetchone()
print("Database version: %s " % data)
# Close the connection
conn.close()
import pyodbc
# Establish a connection
conn = pyodbc.connect(
'DRIVER={SQL Server};'
'SERVER=your_server;'
'DATABASE=your_database;'
'UID=your_username;'
'PWD=your_password'
)
# Create a cursor object
cursor = conn.cursor()
# Execute a query
cursor.execute("SELECT @@VERSION")
# Fetch and print the result
data = cursor.fetchone()
print("Database version: %s " % data)
# Close the connection
conn.close()