If you’re trying to extract values from a JSON document, but one or more of the values on the same level have duplicate keys, you might run into problems if you try to extract those values using JSON_QUERY() or JSON_VALUE().
Both of those functions will only return the first value that matches the path.
Fortunately, there’s another option.
The OPENJSON() function will return all values from any duplicate keys on the same level.
Have you ever run a stored procedure, only to be overwhelmed at the number of columns returned? Maybe you only needed one or two columns, but it presented you with way too many columns for your needs on this particular occasion.
Fortunately, there’s a little trick you can use to retrieve selected columns from a stored procedure. This enables you to get just the columns you need.
And the best part is, it doesn’t involve having to create temporary tables and shuffling the data around.
All you need to do is pass your stored procedure to the OPENROWSET() function.
The same concept can be applied to the OPENQUERY() function.
If you use Azure Data Studio for your database admin tasks, you might be wondering how you can view the execution plan for your queries?
Fortunately, this is easy!
You have the option of viewing:
You can use the T-SQL EXCEPT operator in SQL Server to return distinct rows from the left input query that aren’t output by the right input query.
In SQL Server, you can use the T-SQL INTERSECT operator to return distinct rows that are output by both the left and right input queries.
This article lists the SQL SELECT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article is Part 3 of the Microsoft Access tutorial.
Here’s what’s included in this article:
To use the Query Designer in SQL Server:
The query will appear in the query window. To run the query, click ! Execute or press F5
Below are screenshots for the above steps.
To create a query in Access 2013 or 2016:
The results of the query will be displayed.
You also have the option of saving your query. To save the query, right-click on the query tab. click Save, and name it at the prompt.