pymssql

import pymssql
import os

# Environment variables are recommended for sensitive credentials
SERVER = os.environ.get('PYMSSQL_SERVER', 'your_server.database.windows.net')
USER = os.environ.get('PYMSSQL_USER', 'your_username')
PASSWORD = os.environ.get('PYMSSQL_PASSWORD', 'your_password')
DATABASE = os.environ.get('PYMSSQL_DATABASE', 'your_database')

try:
    # Establish connection using a context manager
    with pymssql.connect(server=SERVER, user=USER, password=PASSWORD, database=DATABASE) as conn:
        print("Successfully connected to SQL Server!")
        # Create a cursor, with results returned as dictionaries
        with conn.cursor(as_dict=True) as cursor:
            # Execute a query
            cursor.execute('SELECT @@VERSION as server_version, GETDATE() as current_time')
            
            # Fetch one row and print it
            row = cursor.fetchone()
            if row:
                print(f"Server Version: {row['server_version']}")
                print(f"Current Server Time: {row['current_time']}")
            
            # Example: Insert data (if autocommit is False, call conn.commit())
            # cursor.execute("INSERT INTO YourTable (Col1, Col2) VALUES (%s, %s)", ('value1', 123))
            # conn.commit() 

except pymssql.OperationalError as e:
    print(f"Connection failed: {e}")
except Exception as e:
    print(f"An unexpected error occurred: {e}")