In SQL Server 2025 (and an upcoming update of Azure SQL), the JSON_VALUE () function will be improved to support a RETURNING clause, allowing specifying the data type coming out of the JSON property.

You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

Learn how to install and configure SQL Server Management Studio, download a SQL Server, and connect them on a Windows 11/10/Server computer..

Get started with new generative AI experiences on Azure SQL and SQL Server, including Azure SQL Database. Learn more.

Need to use raw SQL with JPA and JPA? The Jakarta Persistence API's NativeQuery interface makes it possible to use Hibernate, SQL and JPA together in the same app.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Overview Modern databases, such as PostgreSQL, natively support JSON as data values that can be queried. This capability uses JSON-specific operators, including an operator to test for key presence.