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
In questa pagina del sito puoi guardare il video online sp_execute_external_script to Push and Pull Python Data With SQL Server della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Kutech Solutions Ltd 22 aprile 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 365 volte e gli è piaciuto 10 spettatori. Buona visione!