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()