Posts

Showing posts from 2023

A simple proc to display the number of records in each table in a DB SQL 2017 and above

Streamlining Field Comparisons Between Large Tables with Dynamic Mapping

MYSQL data time conversion with datetime Offset in MSSQL Server

Converting JSON Key-Value Pair Dataset into HTML

Split a string based on Capital letters in a string

Read any Json data into a table structure using Dynamic SQL and save time write long queries.