November 19, 2020 at 12:00 am
Comments posted to this topic are about the item Valid Languages
November 19, 2020 at 7:59 am
This was removed by the editor as SPAM
November 19, 2020 at 9:55 am
In SQL Server 2019, Java, Python, and R runtimes are supported.
So not every language can be added with a language extension, or am I misreading this?
November 19, 2020 at 6:48 pm
https://docs.microsoft.com/en-us/sql/language-extensions/language-extensions-overview?view=sql-server-ver15
In SQL Server 2019, Java, Python, and R runtimes are supported.
So not every language can be added with a language extension, or am I misreading this?
It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
November 20, 2020 at 6:31 am
I've added the R and Python support but it doesn't seem to be worth the effort.
I'm currently learning Python which I find a Superior Language and one day will try again to access SQL Server with it.
November 20, 2020 at 9:34 am
It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
I have. But see also the second line in the article: For Machine Learning Services, Python and R are supported languages. For Language Extensions, Java is supported but must be defined with CREATE EXTERNAL LANGUAGE.
Another reference: https://docs.microsoft.com/en-us/sql/language-extensions/concepts/extensibility-framework?view=sql-server-ver15
Learn about the extensibility architecture used for SQL Server Language Extensions, which allows you to run external code in SQL Server. In SQL Server 2019, Java, Python and R are supported.
So all documentation seems to say 'Yes, you can create external languages, but at the moment the only external language you can create is Java'.
November 20, 2020 at 5:19 pm
George Vobr wrote:It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
I have. But see also the second line in the article: For Machine Learning Services, Python and R are supported languages. For Language Extensions, Java is supported but must be defined with CREATE EXTERNAL LANGUAGE.
Another reference: https://docs.microsoft.com/en-us/sql/language-extensions/concepts/extensibility-framework?view=sql-server-ver15
Learn about the extensibility architecture used for SQL Server Language Extensions, which allows you to run external code in SQL Server. In SQL Server 2019, Java, Python and R are supported.
So all documentation seems to say 'Yes, you can create external languages, but at the moment the only external language you can create is Java'.
Yes, you say it exactly. I understand it the same way, but I'm not sure if it is not possible to use e.g. C++. Perhaps the correct explanation is that R and Python are available directly, but if you want to define an external language Java, you must use CREATE EXTERNAL LANGUAGE. But the use of C ++ is not supported on SQL Server 2019, so I gave a bad example ...
November 20, 2020 at 6:25 pm
There is no support for other languages right now, however, you can't just use Java to execute a script. This might be nit picky, and perhaps the answers aren't good, but you have to use CREATE LANGUAGE to add Java for now. Other languages are coming, but for now, the only supported one in CREATE LANGUAGE is Java.
November 20, 2020 at 6:50 pm
Thanks Steve for this explanation, I understand. The current state is well stated in What you can do with Language Extensions.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply