Learn the basics of SQL stored procedures and functions, how to create and use them, and some best practices and tips for database development.

Learn about the potential drawbacks of recursion in terms of performance and readability in stored procedures, and how to overcome them with alternatives and best practices.

ANSI SQL 99 adds a recursive query capability which permits it.<BR><BR>SQL Server 2005 will add recursive query capability to T-SQL, but for no good reason doesn't use the ANSI syntax.