import pyodbc

# Connecting to MSSQL
conn = pyodbc.connect(
    'DRIVER={ODBC Driver 17 for SQL Server};'
    'SERVER=your_server;'
    'DATABASE=your_database;'
    'UID=your_username;'
    'PWD=your_password'
)
cursor = conn.cursor()

# Creating a table
cursor.execute('
    CREATE TABLE users (
        id INT PRIMARY KEY,
        name NVARCHAR(50),
        age INT
    )
')

# Inserting data
cursor.execute("INSERT INTO users (id, name, age) VALUES (1, 'Alice', 25)")
conn.commit()

# Querying data
cursor.execute("SELECT * FROM users")
for row in cursor:
    print(row)

conn.close()