Python Script [SQL] sp_configure sp_execute_external_script
-- Allow to execute external scripts such as R and PythonEXEC sp_configure 'external scripts enabled', 1;RECONFIGURE WITH OVERRIDE;GO -- Restart SQL Server to apply changes -- Check whether the Python script works well or notEXEC sp_execute_external_script@language = N'Python',@script = N'import sysimport numpy as npimport pandas as pdprint(sys.version)print(np.__version__)print(pd.__version__)';
Piece
2018. 6. 30. 08:31