python on sql

USE [DemoDb]
GO
execute sp_execute_external_script
@language = N'Python',
@script = N'
a = 1
b = 2
c = a/b
d = a*b
print(c, d)
'

execute sp_execute_external_script
@language = N'Python',
@script = N'
MyOutput = MyInput
',
@input_data_1_name = N'MyInput',
@input_data_1 = N'SELECT 1 as Col1',
@output_data_1_name = N'MyOutput'
WITH RESULT SETS ((ResultValue int))

execute sp_execute_external_script
@language = N'Python',
@script = N'
MyOutput = MyInput
',
@input_data_1_name = N'MyInput',
@input_data_1 = N'SELECT [customer]
,[orders]
,[items]
,[cost] FROM [DemoDb].[dbo].[Sales.Orders]',
@output_data_1_name = N'MyOutput'
WITH RESULT SETS (("CustomerID" int, "Orders" float,"Items" float,"Cost" float));

execute sp_execute_external_script
@language = N'Python',
@script = N'
a = 1
b = 2
c = a/b
print(c)
s = pandas.Series(c, index =["simple math example 1"])
print(s)
'

execute sp_execute_external_script
@language = N'Python',
@script = N'
import pandas as pd
a = 1
b = 2
c = a/b
d = a*b
s = pandas.Series([c,d])
print(s)
df = pd.DataFrame(s)
OutputDataSet = df
'
WITH RESULT SETS (( ResultValue float ))

转载于:https://www.cnblogs.com/kingreatwill/p/9081951.html