GitHub

select-transact-sql.md

The UNION, EXCEPT, and INTERSECT operators can be used between queries to combine or compare their results into one result set. :::image type="icon" source ...
TechRepublic

How to query multiple tables in SQL

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...
crossjoin.co.uk

Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true

Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres ...
Microsoft

JSON in SQL Server 2016: Part 4 of 4

In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause. If you are familiar with the FOR XML clause, you will easily ...
Microsoft

Query Store hints in SQL Server 2022

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...
GitHub

select-order-by-clause-transact-sql.md

Sorts data returned by a query in [!INCLUDE ssNoVersion]. Use this clause to: Order the result set of a query by the specified column list and, optionally, limit the rows returned to a specified range ...