My first stored procedure for MySQL - Part 1
I went off stored procedures for a long while. I got pretty good at T-SQL in SQL Server 2000 a few years ago, having written some hundred odd procedures for a single website. The reason I went off them came down to maintenance. I guess, because they are not really 'connected' to your app logic, it makes it tricky to refactor stuff and get to grips with exactly what might be calling what. Coupled with our total shift over to MySQL, it means I haven't written a sproc for a long time.