{"id":1116,"date":"2015-08-19T12:19:14","date_gmt":"2015-08-19T11:19:14","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=1116"},"modified":"2015-08-21T16:30:39","modified_gmt":"2015-08-21T15:30:39","slug":"thresqlips-series-xml-auto-path-episode-2","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/thresqlips-series-xml-auto-path-episode-2\/","title":{"rendered":"#Thresqlips series #XML, Auto & Path – Episode 2"},"content":{"rendered":"

Welcome back to the weekly #thresqlips<\/a>\u00a0series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary:<\/p>\n

Thresqlip No 1.<\/strong>\u00a0The RAW option can be used with the ROOT or ELEMENTS keywords or both to customize your expected XML stream. The ROOT and ELEMENTS keywords are optional.<\/p>\n

Thresqlip No 2<\/strong>\u00a0\u00a0Raw and Auto modes both can use the ELEMENTS option. If ELEMENTS is not used, then both Raw and Auto will display your XML stream in attributes.<\/p>\n

Thresqlip No 3.<\/strong>\u00a0\u00a0Path mode queries recognize a syntax called XPath to easily customize the layout.<\/p>\n

What a #Thresqlip<\/strong> is? \u00a0A #Thresqlip <\/strong><\/a>is that sneaky piece of information that sometimes eludes you exactly when you need it. It’s that 3 seconds tip that you get from one of your colleagues and unblocks that piece of code you’re trying to fit together.\u00a0Ultimately a \u00a0#Thresqlip <\/strong><\/a>is the coolest thing that has been around since the beginning of software development helping developers all around the world, pretty much just like a Super Hero.<\/p>\n

Why three ? Well, One is too little, two is not enough and three is the magic number.<\/p>\n

\"i-have-a-dream
\nLike Martin Luther King Jr we too have a dream, we will get all the #Thresqlips<\/a> together.
\nIf you find yourself in the possession of a\u00a0#Thresqlip <\/strong><\/a>that you’re just dying to share with the world send it across to thresqlips [ at ] dotnetsql.info<\/strong>\u00a0or post it as a comment below and we’ll make sure it will get the proper recognition.<\/p>\n

Until next time,<\/em><\/strong><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 keep learning,<\/em><\/strong>\u00a0keep\u00a0<\/em><\/strong>searching\u00a0and keep succeeding!<\/em><\/strong><\/p>\n

Powered by CodeReview \u2013 Let\u2019s make it Better!<\/a><\/strong><\/em><\/p>\n

 <\/p>\n

Share this:<\/h3>