Pusula

SQL Inner Join — How to join multiple tables in SQL?

This kind of join logically connects 2 or more tables on the given condition and fetches you only the matching records from both the tables. Consider this join as Intersection in the mathematical set ...
Pusula

RIGHT OUTER JOIN — Joining multiple tables in SQL

Just like LEFT OUTER JOIN, RIGHT OUTER JOIN is also a type of OUTER JOIN which fetches you data from multiple tables but this time it fetches all the data from RIGHT table and only matching data from ...
Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...