| title | Graph Functions (Transact-SQL) | |
|---|---|---|
| description | Graph Functions in this section are used to extract values from, and transform values to, the pseudo-columns used in SQL Graph. | |
| author | arvindshmicrosoft | |
| ms.author | arvindsh | |
| ms.date | 06/28/2023 | |
| ms.service | sql | |
| ms.subservice | t-sql | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| dev_langs |
|
|
| monikerRange | = 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 |