SQL Server 语言扩展中有哪些新增功能?What's new in SQL Server Language Extensions?
适用于:Applies to: SQL Server 2019 (15.x)SQL Server 2019 (15.x)
SQL Server 2019 (15.x)SQL Server 2019 (15.x)适用于:Applies to:
SQL Server 2019 (15.x)SQL Server 2019 (15.x)
SQL Server 2019 (15.x)SQL Server 2019 (15.x)
随着我们继续扩大、扩展和深化外部语言与数据平台之间的集成,每个版本的 SQL Server 中都将添加语言扩展功能。Language Extension capabilities are added to SQL Server in each release as we continue to expand, extend, and deepen the integration between external languages and the data platform.
SQL Server 2019SQL Server 2019
可在下面找到 SQL Server 2019 中的语言扩展新功能。The new capabilities for Language Extension in SQL Server 2019 can be found below. 有关此版本中所有功能的详细信息,请参阅 SQL Server 2019 中的新增功能和 SQL Server 2019 的发行说明。For more information about all of the features in this release, see What's New in SQL Server 2019 and Release Notes for SQL Server 2019.
新 Python 和 R 语言扩展New Python and R language extensions
语言扩展提供 Python 自定义运行时。A Python custom runtime is available with Language Extensions. 有关详细信息,请参阅如何在 Windows 上安装 Python 自定义运行时或在 Linux 上安装 Python 自定义运行时。For more information, see how to Install a Python custom runtime on Windows or Install a Python custom runtime on Linux.
语言扩展提供 R 自定义运行时。An R custom runtime is available with Language Extensions. 有关详细信息,请参阅如何在 Windows 上安装 R 自定义运行时或在 Linux 上安装 R 自定义运行时。For more information, see how to Install a R custom runtime on Windows or Install a R custom runtime on Linux.
新 Java 语言扩展New Java language extension
- Windows 和 Linux 上的默认 Java 运行时是 Open Zulu JRE,并且包含在 Windows 上的 SQL Server 语言扩展安装和 Linux 上的 SQL Server 语言扩展安装中。The default Java Runtime on Windows and Linux is Open Zulu JRE and is included with the SQL Server Language Extensions installation on Windows and SQL Server Language Extensions installation on Linux.
- 支持的 Java 数据类型。Supported Java data types.
- CREATE EXTERNAL LANGUAGE,用于在 SQL Server 中注册外部语言(例如 Java)。CREATE EXTERNAL LANGUAGE for registering external language (for example, Java) in SQL Server.
- 用于 Java 的 Microsoft 扩展性 SDK。Microsoft Extensibility SDK for Java.
- 在 Windows 和 Linux 上,可以使用 CREATE EXTERNAL LIBRARY (Transact-SQL) 语句在外部库中访问 Java 代码。On Windows and Linux, Java code can be accessed in an external library using the CREATE EXTERNAL LIBRARY (Transact-SQL) statement. 了解详细信息:如何从 SQL Server 调用 Java。Learn more: How to call Java from SQL Server.
- Windows 和 Linux 上的 Java 语言扩展。Java language extension on Windows and Linux. 可以通过分配权限并设置路径,使编译后的 Java 代码可用于 SQL Server。You can make compiled Java code available to SQL Server by assigning permissions and setting the path. 可访问 SQL Server 的客户端应用可以使用数据并通过调用 sp_execute_external_script 运行代码,这与 SQL Server 机器学习服务上用于 R 和 Python 集成的过程相同。Client apps with access SQL Server can use data and run your code by calling sp_execute_external_script, the same procedure used for R and Python integration on SQL Server Machine Learning Services.
后续步骤Next steps
- 在 Windows 或 Linux 上安装 SQL Server 语言扩展。Install SQL Server Language Extensions on Windows or on Linux.