VM Blogs
Sharing my experiences with SQL programming...
Sunday, May 3, 2020
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-nu...
2 comments:
Monday, February 3, 2020
SQLServer : Real Time Streaming RDBMS Data Using Apache Kafka Platform
›
Problem Statement There is an application database hosted in a SQLServer instance which is capturing data from a automation software i...
Thursday, August 1, 2019
Graph Table Enhancements : Edge Constraints, Utility Functions
›
The second part of the article https://visakhm.blogspot.com/2017/05/graph-tables-in-sql-2017.html can be found here https://social.tec...
Wednesday, April 10, 2019
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 ...
Monday, October 29, 2018
SQL Tips: String Or Binary Data Truncated Error Message Enhancement
›
Introduction I'm sure lots of us who have been developing in SQLServer over ages would agree to the fact that the error String o...
›
Home
View web version
