locked
Python in TSQL RRS feed

  • Question

  • Are there any advantages to run python scripts within a TSQL ??
    Wednesday, July 18, 2018 2:11 AM

Answers

    1. 1.Eliminate data movement (having to transfer data samples from a database to a Python IDE using local compute resources)
    2. 2. Easily operationalize Python code inside SQL.
    3. 3. Achieve enterprise grade performance and scale (much faster mechanism than ODBC)
    • Marked as answer by sakurai_db Friday, August 21, 2020 4:30 AM
    Tuesday, August 18, 2020 7:34 AM

All replies

  • any one has the idea ?
    Wednesday, July 18, 2018 3:54 AM
  • no one has any idea ?
    Tuesday, July 31, 2018 2:47 AM
  • Hi,

    Yes we can run Python script on SQL Server.

    Please find below link which walk you through how to run python scripts using T-Sql.

    https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/run-python-using-t-sql?view=sql-server-2017

    Let me know if you need further assistance.

    Thanks,


    Deepak Narayan


    Thursday, September 27, 2018 2:39 PM
  • Hi,

    Yes we can run Python script on SQL Server.

    Please find below link which walk you through how to run python scripts using T-Sql.

    https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/run-python-using-t-sql?view=sql-server-2017

    Let me know if you need further assistance.

    Thanks,


    Deepak Narayan
    Thursday, September 27, 2018 2:43 PM
    1. 1.Eliminate data movement (having to transfer data samples from a database to a Python IDE using local compute resources)
    2. 2. Easily operationalize Python code inside SQL.
    3. 3. Achieve enterprise grade performance and scale (much faster mechanism than ODBC)
    • Marked as answer by sakurai_db Friday, August 21, 2020 4:30 AM
    Tuesday, August 18, 2020 7:34 AM