sp_execute_external_script to Push and Pull Python Data With SQL Server
SQL Server 2017 and above allows the use of Machine Learning languages such as Python and R directly in T-SQL using sp_execute_external_script. However, it's not always useful being able to simply run the code, we also want to pass data to the script in table and variable form along with receiving tables and variables back.
This video shows how we can do all of these using Python as our language (although this will work in just the same way for R).
Check out our other videos as well, we cover basic PowerShell and Docker alongside our SQL Server based content and we're hoping to expand out further into Power BI, Python, R and other areas.
Please don't forget to Like and Subscribe.
And if you want the scripts, you can find them all on our blog.
Kutech.co.uk - Our one stop SQL shop for Training, Consultancy, and Remote DBA and Support Services
Sur cette page du site, vous pouvez voir la vidéo en ligne sp_execute_external_script to Push and Pull Python Data With SQL Server durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Kutech Solutions Ltd 22 avril 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 365 fois et il a aimé 10 téléspectateurs. Bon visionnage!
