My friend and mentor Madhivanan had posted an interesting scenario on his blog https://exploresql.com/2020/05/01/fun-with-sql-find-out-numbers-where-adjacent-digit-differs-by-1/ and gave it as a challenge for others The question was below I decided to have a try myself on thisHere;s my version of the query…
Graph Table Enhancements : Edge Constraints, Utility Functions
The second part of the article https://www.dataplatformcentral.com//2017/05/30/graph-tables-in-sql-2017/ can be found here https://social.technet.microsoft.com/wiki/contents/articles/53162.graph-table-enhancements-edge-constraints-system-utility-functions.aspx Here I have explained on the concept of Edge Constraints and how they can be used to enforce the relationships between Node tables within an Edge table. The article also…
T-SQL Tips: Generating Nested XML Structures Efficiently Using FLOWR Expressions
Introduction I have been thinking about publishing an article on this for quite a while now. Of late have been too busy (or may be lazy is a better word!) to write on this. Finally thought of breaking the . …