import pymssql

# 连接到 SQL Server 数据库
server = "192.168.77.125"         # SQL Server 地址，例如 "localhost" 或 IP
port = 1433                    # 端口号，默认 1433
user = "sa"         # 数据库用户名
password = "Yahua3585668"     # 数据库密码
database = "TDDB"     # 数据库名称

try:
    conn = pymssql.connect(server=server, user=user, password=password, database=database, port=port, tds_version='7.0')
    print("Connected to SQL Server")

    # 创建游标对象
    cursor = conn.cursor()

    # 执行 SQL 查询
    cursor.execute("SELECT * FROM t_yh_ym801_noon")

    # 获取查询结果
    row = cursor.fetchone()
    while row:
        print(row)
        row = cursor.fetchone()

except pymssql.DatabaseError as e:
    print(f"Database error: {e}")
finally:
    if conn:
        conn.close()
