python sqlserver

下载pymssql.exe，双击安装  http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql

import pymssqlconn = pymssql.connect(host="10.19.1.50",user="sa",password="123",database="GuBei_Data")cursor = conn.cursor()cursor.execute("select * from tblComment")rows=cursor.fetchall()print rowscursor.execute("INSERT INTO tblComment([ID],[Number],[visitor],[comments]) VALUES(5,'view3','youke4','very done')")conn.commit()printcursor.close()conn.close()