I have some experience with SQL and python.
In one of my SQL stored procedures I want to use some python code block and some functions of python numpy.
What is the best way to do it.SQL server version is 2014.
First install the MySQL connector for python from the MySQL website and then import the mysql.connector module and initialize a variable to a mysql.connector.connect object and use cursors to modify and query data. Look at the documentation for more help.
If you don't have problem with no networking capabilities and less concurrency use sqlite, it is better than MySQL in these cases.
how to use python inside SQL server 2014