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 MoreSQL Server Education (by the geeks, for the geeks)
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 MoreSQL 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 MoreAlphanumeric 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 MoreOne 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 MoreA 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 MorePaging 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 MoreA 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 MoreHello 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