Skip to content

Latest commit

 

History

History
33 lines (29 loc) · 1.85 KB

graph-functions-transact-sql.md

File metadata and controls

33 lines (29 loc) · 1.85 KB
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
SQL Graph functions
TSQL
= azuresqldb-current || >= sql-server-2017 || >= sql-server-linux-2017 || = azuresqldb-mi-current

Graph functions (Transact-SQL)

[!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

Next steps