Creating a Node Table

Question

Post reply

Creating a Node Table

Steve Jones - SSC Editor

SSC Guru

Points: 730315
More actions
January 28, 2020 at 12:00 am

#3710004

Comments posted to this topic are about the item Creating a Node Table
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Protiguous SSC Eights! Points: 915 More actions · Answer 1

Protiguous

SSC Eights!

Points: 915

January 28, 2020 at 7:22 am

#3720829

The correct answer is 2 or 3??

Stewart "Arturius" Campbell SSC Guru Points: 72321 More actions · Answer 2

Nice question, thanks Steve

Haven't had the opportunity to work with graph tables yet, so learned something new

Protiguous wrote:

The correct answer is 2 or 3??

no, there is no WITH option NODE; the answer could only be 2

This reply was modified 3 years ago by Stewart "Arturius" Campbell.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 3

Think the confusion relates to the text in the Explanation, which in itself is fine but references syntax 3 but gives the right syntax from the correctly marked answer!

Grant Fritchey SSC Guru Points: 398098 More actions · Answer 4

I'm on it!

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Grant Fritchey SSC Guru Points: 398098 More actions · Answer 5

There. Cleared it up.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Protiguous SSC Eights! Points: 915 More actions · Answer 6

Thanks Grant for clearing that up!

(I'm totally new to graph tables.. I've just started on the example provided by Microsoft.)

Grant Fritchey SSC Guru Points: 398098 More actions · Answer 7

Me too. I got the question right through the process of elimination, not knowledge.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software