Rediger

Del via


Graph functions (Transact-SQL)

Applies to: SQL Server 2017 (14.x) and later 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

Next steps