SQL Master

Imagine a situation when you are working on a query for couple of hours and suddenly your management studio is crashed or your PC is restart...

Today 2 of my colleagues from reporting team had this requirement. They had one table where Seconds were stored as INT and in report they wa...

Now lets see how to get alternating row background colors in Reports. This is one of the 1 st typical report enhancement you might be doing...

If you have installed the Evaluation / Trial Version of SQL Server, you may like to find out what is the expiry date of the Trial Version.  ...

Edit: If you are using SQL Server 2012 or 2014 you may like to see my latest post on the topic How to Calculate Running Totals in SQL Server...

Seems to be easy question. And many of you may be already knew 2-3 ways of doing it. Here is the query I use normally to get the all the dat...

In Sql Server 2005 and 2008 you can script the stored procedure in Management Studio by right clicking on Store Procedure name and clicking ...

In one of my previous posts I wrote about “ How to Create a Comma Delimited List ”.  Now I’ll show you an example with reverse action, that ...

In this article I will try to show you a simple example on how to Create a Comma Delimited List from a column also called as CSV (Comma Sepa...

Lets see how to find which Sql Server Version is installed and Service Packs applied on your machine- To know Execute SELECT @@version If y...