Reverse string in SQL Server
SQL Server has in build function REVERSE to reverse string. A T-SQL example is given below The function is very much direct. It takes an input string and returns the reversed …
Reverse string in SQL Server Read MoreTag: tally table
SQL Function to remove characters from string
One of the most common questions over forums is a SQL function to remove characters from string. The function for the same is given below. — Method 1: Loop IF(Object_id(‘dbo.fn_removecharactersfromstring’)) is …
SQL Function to remove characters from string Read MoreGenerate List Dates between Date Range
Recently a developer came to me seeking my help in generate list dates between date range for a report. Being a .Net developer he said that one solution he had is …
Generate List Dates between Date Range Read More