Here's a decent article discussing the new-to-2005 XML data type:

  http://www.windowsitpro.com/Article/ArticleID/45131/45131.html

Start: Run: svrnetcn

I think the author meant his SET was commented out by accident.

This example demonstrates SQL Server's default behavior when concatenating strings;  if any of the strings is unknown (NULL) then...

I second the nomination;  ApexSQL Doc is a great tool for producing dynamic .chm file documentation. 

I tried pulling down the .pdf for March but got January's ish?  Anybody else had trouble? 

1.  Log in to the OS as administrator.

2.  If yours is a default instance of SQL Server, check the following value to make sure it set to a 0 (if...

I've heard the next release of SQL Server will support dynamic TOP(n) like you've written, but until then, some dynamic SQL should do the job:

DECLARE @top varchar(10)

DECLARE @sql varchar(100)

SET @TOP...