Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE sp_execute_external_script
- @language =N'Python',
- @script=N'
- print(''hello world'')
- ';
- EXEC sp_execute_external_script
- @language = N'Python',
- @script = N'
- import pip
- import pandas as pd
- installed_packages = pip.get_installed_distributions()
- installed_packages_list = sorted(["%s==%s" % (i.key, i.version)
- for i in installed_packages])
- df = pd.DataFrame(installed_packages_list)
- OutputDataSet = df
- '
- WITH RESULT SETS (( PackageVersion nvarchar (150) ))
- EXECUTE sp_execute_external_script
- @language =N'Python',
- @script=N'
- import sys
- import codecs
- import requests
- tmp = ''7805729430''
- headers = {
- ''Content-Type'': ''application/json'',
- ''Accept'': ''application/json'',
- ''Authorization'': ''Token _token_'',
- }
- data = ''{ "query": '' + tmp + ''}''
- response = requests.post(''url'', headers=headers, data=data)
- ';
Add Comment
Please, Sign In to add comment