SQL function to get weekday – weekly calendar
In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly …
Read MoreTag: CTE
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 …
Read MoreFunction to parse alphanumeric characters from string in SQL Server
Alphanumeric string consists of alphabets and numbers for example a string 123xyz456abc is an alphanumeric string. Many a times it is required to extract only alphanumeric characters from a string excluding …
Read MoreSQL 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 …
Read MoreSQL function to extract number from string
A common question among forum is a SQL function to extract number from string. Let’s see how this can be achieved. One way to achieve this is with while loop as …
Read MoreT SQL paging stored procedure
Paging is a process of splitting large result set into subset of pages. So, instead of displaying 5000 records resulting from a search, first 20 records are shown and then next …
Read MoreT-SQL script to find duplicates
A common task for DBAs/Developers is to find duplicates in tables to avoid redundancy and storage misuse. Here is a T-SQL script to find duplicates. Create table tblDup(Sno int identity, Col1 …
Read MoreSQL Server – What is Common Table Expression (CTE)?
Hello Folks, You must have heard CTE before. If you don’t know much about it, then don’t worry at all. I will be giving you some heads up: The Common Table …
Read More