tsql - sp_execute_external_script @language = N'R' -

how can - create 2 input data set referenced in @script

example

exec sp_execute_external_script @language = n'r'      , @script = n' outputdataset <- inputdataset'      , @input_data_1 = n''      , @input_data_2 = n'' -- line.     , @input_data_1_name = n'inputdataset'      , @output_data_1_name = n'outputdataset'   result sets ((plot nvarchar(max))); 

you have use @params if want more 1 input/output. assign data parameter of exact same name right after it.

exec sp_execute_external_script @language = n'r'      , @script = n'         notusedagain <- seconddataset;          outputdataset <- inputdataset          '      , @input_data_1 = n''      , @params = n'@seconddataset int'     , @seconddataset = 1   result sets ((plot nvarchar(max)));