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 »