SQL Master

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...

Lets see How to create a linked server with Excel 2007. Well most of the stuff you'll find on the net on how to create a linked Serve...

  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 Se...

Edit: If you are using SQL Server 2012 or 2014 you may like to see my new post on this topic: LPAD and RPAD Functions in SQL Server In Sql...