SQL Server: How to remove First and Last character from string

Introduction :  In this article I am going to explain How to remove first and last character from string in sql server. We will also update...

SQL Server: How to Toggle / Flip / Invert value of Bit column

Introduction :  In this article I am going to share some methods to invert / flip / toggle value of a bit field / column in sql server i.e....

SQL SERVER: Function to check column exists in table or not?

Introduction :   In this article I am going to explain how to check whether column exists in table or not; if not only then add the column....

SQL SERVER: How to split or convert delimited string into rows without using function

Introduction :   In this article I am going to explain How to convert or split the delimited string (comma separated string) into table row...

Sql server: How to sort alphanumeric string data in table

Introduction :   In this article I am going to explain how to sort alphanumeric string data/records in sql table.  In previous articles...

SQL SERVER: CTE recursive query to get parent child hierarchy with levels

Introduction :  In this article I am going to explain how to create parent-child hierarchy( Continent-> Country-> State-> City ) w...

Sql Server: Case statement to Sort records by different columns of different data types

Introduction :  Here in this article I am going to explain how to use CASE statement in Order by clause to sort records with different colu...

SQL Server: Count employees based on their months/days of experience | Get Experience wise employee summary.

Introduction :  In this article I am going to share how to count employees based on their months or days of experience or we can say query ...

SQL Server: Count employees based on their years of experience | Get Experience wise employee summary.

Introduction :  In this article I am going to share how to count employees based on their years of experience or we can say query to get ex...