January 28, 2020 at 12:00 am
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
January 28, 2020 at 7:22 am
The correct answer is 2 or 3??
January 28, 2020 at 7:58 am
Nice question, thanks Steve
Haven't had the opportunity to work with graph tables yet, so learned something new
The correct answer is 2 or 3??
no, there is no WITH option NODE; the answer could only be 2
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
January 28, 2020 at 11:47 am
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!
January 28, 2020 at 1:11 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 28, 2020 at 1:22 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 28, 2020 at 2:20 pm
Thanks Grant for clearing that up!
(I'm totally new to graph tables.. I've just started on the example provided by Microsoft.)
January 28, 2020 at 2:33 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply