pymssql

pymssql

TEXT
1
import pymssql

建立连接

TEXT
1
conn = pymssql.connect(server='server_name', user='username', password='password', database='database_name', port=port_number)

创建游标

TEXT
1
cursor = conn.cursor()

执行查询

TEXT
1
cursor.execute('SELECT * FROM table_name')

获取结果

获取一行结果

TEXT
1
row = cursor.fetchone()

获取所有结果

TEXT
1
rows = cursor.fetchall()

提交更改

TEXT
1
conn.commit()

关闭连接

TEXT
1
conn.close()