关于python操作mssql

详情参考 https://pymssql.readthedocs.io/en/latest/ref/pymssql.html?highlight=port#pymssql.connect

pymssql.connect(server='.', user=None, password=None, database='', timeout=0, login_timeout=60, charset='UTF-8', as_dict=False, host='', appname=None, port='1433', conn_properties=None, autocommit=False, tds_version=None)

以下代码适用于多个实例在一个服务器的情况，这里的端口8433 是因为实例2 【sql server configuration mangager】【tcp/ip】里面最底下设置的端口号码。默认是1433

from pymssql import _mssql
server='127.0.0.1'
user='sa'
password='0123456'
database = 'run'
conn = pymssql.connect(server, user, password,database,port='8433')
cursor = conn.cursor()
cursor.execute('SELECT * FROM sysconfig')

for row in cursor:
    print('row = %r' % (row,))

conn.close()