python连接sql server并执

import pymssql

#数据库服务器信息
server="localhost"
user="sa"
password="grkj"
database="WeatherDataDB"

conn=pymssql.connect(server,user,password,database)
cur = conn.cursor()
sql = "select * from Province"
cur.execute(sql)
rows = cur.fetchall()
conn.close()
for row in rows:
    print row[0]