SQL Master

In this part I’ll help you in creating a Linked Server with Excel. Or simply how to import/query Excel in Sql Server. In Sql Server 2005 yo...

Here is the good collection of views and Store Procedure which can be very useful. Applicable for Sql Server 2005 and + VIEWS : To use all t...

Now I'll try to help you understand the connection issues with Sql Server. Today we will focus on the error "Msg 18456, Level 14, S...

In this post I will try to explain how to convert date in required format. As we know by default (U.S. English) Sql Server shows dates in md...

What is the Difference between ROW_NUMBER , RANK and DENSE_RANK ? Which one to use? This is very common question in the minds of SQL ...