

EXEC sp_execute_external_script
@language =N'Python',
@script=N'OutputDataSet = InputDataSet',
@input_data_1 =N'SELECT 1 AS Bonjour'
WITH RESULT SETS (([Bonjour] int));
GO

----------------

EXECUTE sp_execute_external_script
    @language = N'Python'
    , @script = N'OutputDataSet = InputDataSet;'
    , @input_data_1 = N'SELECT [Spales.Longueur] FROM iris_donnes;'
WITH RESULT SETS (([Longueur des spales] INT NOT NULL));

----------------

EXECUTE sp_execute_external_script
  @language = N'Python'
  , @script = N'Sortie = Entre'
  , @input_data_1 = N' SELECT 10 as Col;'
  , @input_data_1_name  = N'Entre'
  , @output_data_1_name =  N'Sortie'
  WITH RESULT SETS (([Exemple] INT NOT NULL));

----------------

EXECUTE sp_execute_external_script
@language = N'Python'
, @script = N'
import pandas as pd
variable = pandas.Series(["Bonjour", "le", "monde"]);
OutputDataSet = pd.DataFrame(variable);'
, @input_data_1 = N''
WITH RESULT SETS (([Rsultat] CHAR(20) NOT NULL));

----------------

EXECUTE sp_execute_external_script
    @language = N'Python'
    , @script = N'OutputDataSet = InputDataSet;'
    , @input_data_1 = N'SELECT [Spales.Longueur] FROM iris_donnes;'
WITH RESULT SETS (([Longueur des spales] INT NOT NULL));