python 连接MSSQL

# -*- coding: utf-8 -*-
import pymssql


conn=pymssql.connect(host=".",user="sa",password="",database="UFDATA_001_2013",charset="utf8")
#conn=pymssql.connect(host="kzxserver",database="UFDATA_001_2014",trusted=True)
cur=conn.cursor()
cur.execute('SELECT * FROM code')
row = cur.fetchall()
for crow in row:
    print (crow)

 

posted @ 2014-06-28 13:47  似水@流年  阅读(239)  评论(0编辑  收藏  举报
悠悠记得当天笑 仿佛入迷 又带一点惘 种种喜悦 令人为你鼓掌 眉飞色舞千千样 你是个妙人 是个少年狂