Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL.

I'm working on the DB end of a 3-tier web app using an ASP front end, VB to handle the business logic and MSSQL2K as the database. The programmers want to use stored procedures for all database ...