SQL - stored procedures, views, and dynamic sql generation

Posted by Scott_Ruecker on Aug 17, 2006 1:27 AM
By Advogato
Mail this story
Web version

I first started getting significantly involved in SQL back in 2000. Within six months I had written pysqldb (one of the many reinvented dynamic SQL generators available) because hard-coding SQL statements I immediately concluded to be insane. I was constantly battling the management of the project because they wanted to create Views - and to get me to use them. I am now, once again, on a major SQL project, this time involving stored procedures. This article describes the SQL experiences - positive and negative - and outlines some of the advice that I've encountered from different sources.

Full Story

Printed at http://lxer.com/module/newswire/view/67644/index.html