Python Operations SQL Server

# CODING=GBK
Import SYS
Import pymssql




#尝试数据库连接
Try:
conn = Pymssql.connect (host= "192.168.1.43", user= "sa", password= "sa01!", database= "master")
except Pymssql. Operationalerror, msg:
print "Error:could not Connection SQL server!please Check your dblink configure!"
sys.exit ()
Else:
cur = conn.cursor ()








#查询数据库
query= "Select name, database_id, Recovery_model_desc from sys.databases"
cur.execute (query)
Conn.commit
rows = Cur.fetchall ()


print (")
print ('-----results returned in-------')
print (")
For (NAME,DATABASE_ID,RECOVERY_MODEL_DESC) in rows:
database_id=bytes (database_id) #将int转换转换为字符串类型
print (' Database name: ' +STR (name) + '; ')
print (' Database ID: ' +database_id)
Print (' Database recovery model: ' +str (RECOVERY_MODEL_DESC))
print (")
print ('-----above is all results!-------')


#关闭连接, freeing up resources


cur.close ()
conn.close ()

This article is from "Record bit!" "Blog, be sure to keep this provenance http://ocpyang.blog.51cto.com/3401739/1630402

Python Operations SQL Server