New in sql server 2017:
- possibility to process graph . see here
Graph data processing – this give us , the ability to create two new types of tables
– node – holds the entities and could have properties
– edge – holds the relations between nodes/entities.
There are some hidden columns
$node_id …
$edge_id
$from_id
$to_id
Is adding a new clause = MATCH =
Here is an example from microsoft blog:
SELECT Person2.Name
FROM Person Person1, Friends, Person Person2
WHERE MATCH(Person1-(Friends)->Person2)
AND Person1.Name = ‘John’;
see it here
Good stuff , microsoft!
S
Sql Server 