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 »