Fun with SQL – Find out numbers where adjacent digit differs by 1

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…