擅长:python、mysql、java
<p>他们都帮了忙!我必须转换成JSON。还可以查看orient参数的各种选项</p>
<pre><code>DECLARE @answers NVARCHAR(MAX)
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).to_json(orient=''values'')',
@params = N'@df NVARCHAR(MAX) OUTPUT',
@df = @answers OUTPUT
PRINT @answers
</code></pre>