Here is a short example of a recursive stored procedure. It returns the nth piece of a delimited text string using recursion. There are better performing methods for doing this type of task, however, I found it an interesting exercise none the less.
Here is a stored procedure that I find useful for generating a data dictionary on the fly for a SQL Server database. The core of the procedure was pieced together from other scripts I found on the web. This stored procedure should run without modification on SQL Server 2000, 2005 and 2008. The only required [...]