import pymssql
conn = pymssql.connect(host="192.168.0.2", user="sa", password="sa", database="MyDB")
cursor = conn.cursor()
cursor.execute("SELECT * FROM Table")
row = cursor.fetchone()
while row:
print row[1].encode('latin1')
row = cursor.fetchone()
conn.close()
注:SQL Server 2000是latin1编码。