SQL Master

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

In this post I'll show you a simple solution to a very common error you get while running a query against a linked Server . You create a...

Lets see how to delete the duplicate Rows from SQL Server table. Sample Table: ID NAMES CODE ...

Well this is most common question I answered many times on Sql Server MSDN forums. How to remove Time from Datetime column in Sql Server 200...

In my previous post I wrote about Linked Server with Excel. Now we will see how to create a linked server for DBF files. That is accessing ...