ExecRcodeFromSQL.sql

USE master
GO
sp_configure 'external scripts enabled', 1;  
RECONFIGURE WITH OVERRIDE;  

EXECUTE sp_execute_external_script
      @language = N'R'
    , @script = N'
        library(utils);
        mymemory <- memory.limit();
        OutputDataSet <- as.data.frame(mymemory);'
    , @input_data_1 = N' ;'
WITH RESULT SETS (([Col1] int not null));