XML Namespaces are part of element identity, so a matching tag name alone can still miss a node. I compare three paths against one document. The namespace URI stays the same while the query binding changes.
SQL SERVER 2012 – Logical Function CHOOSE() – A Quick Introduction
A quick introduction to the logical function CHOOSE() in SQL Server 2012: it returns the value at a given index from a list, or NULL when out of range.
SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction
A quick introduction to the IIF function in SQL Server Denali, a shorthand for the CASE statement that returns one of two values. It can be nested too.
SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()
SQL Server Denali adds a new conversion function trio: PARSE(), TRY_PARSE() and TRY_CONVERT(). Here are the differences, answered as questions.
SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction
Meet the TRY_CONVERT function in SQL Server Denali. It behaves like CONVERT, except a failed conversion gives you NULL rather than an error.
SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction
A quick introduction to the TRY_PARSE function in SQL Server Denali: it converts a string to a number or date, and returns NULL when it cannot.
SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction
A quick introduction to the PARSE function in SQL Server Denali: convert a string to a number or a date and time, and see what happens when it fails.