Scribd
Upload
23 views1 page

Enable Python in SQL Server

Uploaded by

boyarajesh888
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
23 views1 page

Enable Python in SQL Server

Uploaded by

boyarajesh888
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

-- Check server configuration status

sp_configure

-- Enable external script execution


EXEC sp_configure 'external scripts enabled', 1
RECONFIGURE WITH OVERRIDE

-- Verify server configuration status


sp_configure

-- Restart SQL Server instance

-- Execute a sample Python script


EXEC sp_execute_external_script
@language = N'Python',
@script = N'
print("Hello World")
'

-- Retrieve Python version


EXEC sp_execute_external_script
@language = N'Python',
@script = N'
import sys
print([Link])
'

You might also like