March 2018
Intermediate to advanced
816 pages
19h 35m
English
A node table represents an entity in a graph schema. It must have properties (at least one column). All you need is to finish your CREATE TABLE statement with the AS NODE extension to indicate that the table represents a graph node. The following statements create and populate a node table in SQL Server 2017:
CREATE TABLE dbo.TwitterUser(UserId BIGINT NOT NULL,UserName NVARCHAR(100) NOT NULL) AS NODEGOINSERT INTO dbo.TwitterUser VALUES(1, '@MilosSQL'),(2, '@DejanSarka'),(3, '@sql_williamd'),(4, '@tomaz_tsql'),(5, '@WienerSportklub'),(6, '@nkolimpija');
With the exception of the AS NODE extension, this code is a typical Transact-SQL code, and you did not enter any graph attributes. However, when you look at the table content, you'll ...