SQL Bits Mar 2022
SQLBits March 8 - 12 London Excel www.sqlbits.com-
Recent Posts
- Setting up a big query service account.
- Searching for underscores with LIKE
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 2
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 1
Archives
Categories
Meta
Tag Archives: XQuery
Recursive XML branches
One of the main features of XML is that it handles hierarchical data structures. I agree that so does SQL either using the hierarchy variable or creating a Recursive CTE. but nothing compares to the simplicity of the XML format … Continue reading
modifying data in XML a really clunky solution. (no I mean REALLY Clunky)
If you are trying to replace the value of an element that does not exist if can be problematic, i have not found a nice way to do this, if any one does please let me know. So to get … Continue reading
XML .value simple syntax
There are several ways to get .value to extract an item of information from xml. in the following article I will show some of the syntax and reasons why some methods are better than others. All the calls in this … Continue reading