Every time we used the sp_execute_external_script stored procedure previously, we used just one dataset as an input. However, we will always need more values to be passed back and forth between the T-SQL and external scripts and we also need to provide variable values as inputs for new predictions. This section will explain how to pass values and records between the SQL Server and external scripts and how to work with them inside the external script.
Submitting values to an external script
Submitting values into the external script
The stored procedure, sp_execute_external_script, can interact with the rest of the T-SQL batches using parameters. The procedure contains an input parameter called @params, which is used to declare...