擅长:python、mysql、java
<pre><code>declare @num1 int = 10, @num2 int=5, @thesum int;
EXEC sp_execute_external_script @language=N'Python',
@script = N'
import pandas as pd
ser = pd.Series([6, 7, 6 * 7])
df = pd.DataFrame(ser)
OutputDataSet = df
a=x123
b=y345
sumresult=a+b
',
@output_data_1_name = N'OutputDataSet',
@params = N'@x123 int, @y345 int, @sumresult int output',
@x123= @num1, @y345=@num2, @sumresult = @thesum output
WITH RESULT SETS((Answer int));
select @thesum;
</code></pre>