The March/April 2006 edition of SQL Server Standard magazine is now available. This issue focuses on Transact-SQL for SQL Server 2005. Though I normally focus on the security side of things, I was able to get an article in on Common Table Expressions and Recursion. I used an example from an old intranet web application I had developed in the days before document management systems like SharePoint and others became available, back in 2000. I still remember deploying the application to NT 4.0 systems running IIS 4.0 and SQL Server 7.0. That seems like ages ago giving how both IIS, Microsoft web development technologies, and SQL Server have developed over the years. Having the use of CTEs and recursion back then would have simplified some of the coding but it wasn't available back then.
If you're interested in taking a look at the contents of the most
recent issue of SQL Server Standard magazine, you can find that
information at the following link: http://www.sqlserverstandard.com/issue/.
It's also where you can order an electronic copy of the magazine. If
you want to subscribe to the magazine, the following link gets you to
that information: http://www.sqlserverstandard.com/subscribe/. If you're an MCP and have registered on Microsoft's MCP Member Site, you can download issues for free from the Special Offers & Events link.
IT Security, MySQL, Perl, SQL Server, and Windows technologies.