How to find whether the date is end date of the month in SQL

Working with date is very interesting, I have seen people add too much code to get desired result while it can be achievable with simple logic. Below sample is to…

Read more »

How to find the Date is first day of the Week in SQL

Some time you may need to find the given date is first day of the week or not? here is the code.

Read more »

Concatenate column values from multiple rows into a single column in SQL Server

I have created a simple table to demonstrate how to concatenate the values from multiple rows in to one column. Insert some sample records in to this temporary table Once…

Read more »

JOIN in SQL – Inner Join and Outer Join

JOIN is one of the fundamental units of relational database system. Generally JOIN is used to combine related data from many tables to produce result. There are different types of…

Read more »

SELECT * Vs. SELECT COLUMNS – SQL Server Optimization Techniques

Don’t use * in SELECT query, instead use only required column This is one of the tips to optimize SELECT query. However, does this really give better performance in SQL…

Read more »

How to check if the input is numeric

ISNUMERIC() – This is a system function which can be used to evaluate the given input, if the input is valid numeric it returns 1 otherwise 0. There are times where…

Read more »