学习pymssql
2018-07-10 本文已影响0人
jbc911
# -*- coding:utf-8 -*-
import pymssql
conn = pymssql.connect("localhost","jbc","123","jobplus",charset="utf8")
curs = conn.cursor()
curs.execute("select * from sys.tables")
res = curs.fetchall()
for o in res:
print o[0]
