sa_certificate_info system procedure   This system procedure returns information about certificates stored in the database. See sa_certificate_info system procedure.

sa_cpu_topology system procedure   This system procedure returns information about the processor topology of the computer that the database server is running on. See sa_cpu_topology system procedure.

sa_db_option system procedure   This system procedure allows you to override a database option while the database is running. See sa_db_option system procedure.

sa_parse_json system procedure   This system procedure returns a representation of JSON data using ROW and ARRAY SQL types. See sp_parse_json system procedure.

sa_server_option system procedure   On Windows and Linux, you can change the number of logical processors the database server can use after the database server has been started by using the ProcessorAffinity property of the sa_server_option system procedure. See sa_server_option system procedure.

Directory and file stored procedures   A new set of stored procedures allow you to list and manipulate directories and files that are accessible by the server without requiring the need to set up directory access servers, external logins, and directory access proxy tables. These system procedures can be enabled and disabled as secure features.

xp_get_mail_error_code system procedure   This system procedure returns information about the most recent SMTP or MAPI error when using the xp_ mail procedures. See xp_get_mail_error_code system procedure.

xp_get_mail_error_text system procedure   This system procedure returns information about the most recent SMTP error when using the xp_ mail procedures. See xp_get_mail_error_text system procedure.

xp_getenv system procedure   This system procedure returns the value of an environment variable. See xp_getenv system procedure.

xp_startsmtp system procedure   The trusted_certificates parameter of this system procedure can now contain file=file-path and cert_name=certificate-name options. See xp_startsmtp system procedure.

Subselect and subqueries supported for parameter expressions in functions and procedures.   Subselect and subqueries are supported for parameter expressions in functions and procedures.

BINTOHEX function   This function returns the hexadecimal equivalent of a binary string. See BINTOHEX function [Data type conversion].

HEXTOBIN function   This function returns the LONG BINARY equivalent of a hexadecimal string. See HEXTOBIN function [Data type conversion].