Stack Overflow
Stack Overflow

Questions tagged [sql-server-graph]

Graph database implemented in SQL Server and Azure SQL database. A Microsoft version of graph database.

6 questions
3
votes
1 answer

Need to create a view from a SQL Server Graph Table that does not include the hidden graph_id column

The table was created as a NODE, therefore SQL Server adds a graph_id_xxxxxx column between others. I create a view with the following sentence: CREATE VIEW FILE_VIEW1 AS SELECT [NAME] FROM [dbo].[FILE_NAME] But when I see the columns in the…
Daniel Lederman
  • 31
  • 1
2
votes
2 answers

Get all friends in SQL Server graph database

I'm trying to retrieve all friends of a particular person using SQL Server graph processing Person table as node ╔════╦═══════╗ ║ Id ║ Name ║ ╠════╬═══════╣ ║ 1 ║ David ║ ║ 2 ║ Suraj ║ ║ 3 ║ John ║ ║ 4 ║ Ryan ║ ╚════╩═══════╝ likes as an…
Beingnin
  • 2,288
  • 1
  • 21
  • 37
1
vote
0 answers

SQL Server Graph DB find all path with fix start and end node

I have a sql graph db as follow: Below is my sql script: DROP TABLE IF EXISTS Person; CREATE TABLE Person (userName VARCHAR(100) PRIMARY KEY) AS NODE; INSERT INTO Person (userName) VALUES ('A'),('B'),('C'),('D'),('E'),('F'); DROP TABLE IF…
eulercode
  • 1,107
  • 4
  • 16
  • 29
1
vote
0 answers

How to make LINQPad work with SQL Server's graph?

Graph Table in SQL Server automatically added an internal graph_ID_ column for user. When querying the table in LINQPad, got this error. Here is the SQL being generated in LINQPad. Looks like LINQ_TO_SQL detected this column, and treated this…
Rm558
  • 4,621
  • 3
  • 38
  • 43
0
votes
1 answer

SQL Server graph to fetch multiple node types connected to a node

I'm planning to use SQL Server 2019 graph features for one of my project. The data scheme would look something like the picture below. Given the user (Id: 2356, name: Mark), I would want to retrieve all the Posts and the Tweets done by the user's…
opuser1
  • 427
  • 7
  • 29
0
votes
1 answer

SQL Server Graph Tables - navigate through certain nodes to find end

I have a structure of graph tables containing 2 Node tables and 1 Edge table. Symptom table is a Node table and Syndrome_Causes is an Edge table. Also, there is another Node table called Syndrome. My goal is to have a query where I can traverse my…
Radu Gheorghiu
  • 20,049
  • 16
  • 72
  • 107