python 操作数据库MSSql

import pymssql

con = pymssql.connect(host='192.168.13.122',user='sa',password='',database='tempdb')
cur = con.cursor()

 

query="select top 50 * from t_user_info"  # 执行命令
cur.execute(query)

    while 1:
 print cur.fetchall()
 if 1 == cur.nextset():
     break

con.commit()
con.close()