title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | monikerRange | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Graph Functions (Transact-SQL) |
Graph Functions in this section are used to extract values from, and transform values to, the pseudo-columns used in SQL Graph. |
arvindshmicrosoft |
arvindsh |
06/28/2023 |
sql |
t-sql |
reference |
|
|
= azuresqldb-current || >= sql-server-2017 || >= sql-server-linux-2017 || = azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
Use the functions described on the pages in this section to extract values from, and transform values to, the pseudo-columns used in SQL Graph.
Function | Description |
---|---|
EDGE_ID_FROM_PARTS | Construct an edge_id from object_id and graph_id |
GRAPH_ID_FROM_EDGE_ID | Extract the graph_id from a edge_id |
GRAPH_ID_FROM_NODE_ID | Extract the graph_id from a node_id |
NODE_ID_FROM_PARTS | Construct a node_id from an object_id and a graph_id |
OBJECT_ID_FROM_EDGE_ID | Extract the object_id from an edge_id |
OBJECT_ID_FROM_NODE_ID | Extract the object_id from a node_id |