Nice article. One thing to be careful of when using LEN and DATALENGTH is that it matters whether the column was declared as CHAR or VARCHAR. CHAR will...

I also thought it would delete all the duplicated records. However, when I tested it the code did work. The key is setting ROWCOUNT = 1 which means...

Response to con for XML item, "Difficult to create XML data at the application layer":

Using the ASP.Net C# XmlTextWriter class , I found creating my data in xml format to...