Balajiprasad's useful codes
Important codings & concepts in web & window applications using microsoft technologies.
Showing posts with label
SQL
.
Show all posts
Showing posts with label
SQL
.
Show all posts
Tuesday, February 20, 2024
SQL - Defined vs Dynamic table column values into JSON
›
Convert Defined vs Dynamic table column values into JSON using SQL Syntax, using SQL Pivot and Subquery execution achieved to construct JSO...
Monday, August 24, 2020
SQL - Modify Array of JSON
›
How to copy one array of JSON object into another array of JSON in SQL. Take this below sample copy array of empIds from one JSON into anot...
Tuesday, August 7, 2018
SQL - Split different column names display with separator
›
In some situation, we need to show separator for firstname and middlename. This can be comma if there some values. Lets take sample of em...
›
Home
View web version
