How do I escape a single quote in SQL Server
A single quote can be escaped by doubling them up in MSSQL server. There are many ways to…
How to Delete Duplicate Rows in sql
There are many ways to identify and delete duplicate rows in SQL. The best way to achieve this…
How to find nth highest salary using SQL query
This is a common SQL question which will be asked in most of the interviews and also if…
How to Include Null Values in JSON Output in MSSQL
One of the top features of MSSQL server 2016 is built in support of JSON. The data from…
How to Format Query Results as JSON in MSSQL
One of the top features of MSSQL server 2016 is built in support of JSON. Yes, now we…
How to add root node to JSON output in MSSQL?
MSSQL 2016 has a new feature where you can return the data as JSON output format and also…
How to find size of table in MSSQL?
Everyone would have come across a scenario where there is a need to find the Size of the…