pymssql接続mssql

Win10
Python 3.7.4
conda 4.7.12
pymssql==2.1.4

pip install pymssql

create table animal(
    id int not null,
    name char(20)
)
insert into animal (id, name) values(0, 'dog')
insert into animal (id, name) values(1, 'cat')
insert into animal (id, name) values(2, 'pig')

import pymssql
if __name__ == "__main__":
    try:
    	# hostname       ，   (local)     MSSQL
    	# username   MSSQL   ，   sa
    	# password   MSSQL        
    	# database name       
        mssql_connect = pymssql.connect('hostname', 'username', 'password', 'database name')
        cursor = mssql_connect.cursor()
        sql = 'select * from animal'
        cursor.execute(sql)
        tuples = cursor.fetchall()
        cursor.close()
        mssql_connect.close()
        for tuple in tuples:
            print(tuple[0], tuple[1])
    except:
        print("Error")

0 dog
1 cat
2 pig