SQL - stored procedures, views, and dynamic sql generation

Posted by Scott_Ruecker on Aug 17, 2006 3:27 AM EDT
Advogato; By Luke Kenneth Casson Leighton
Mail this story
Print this story

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

  Nav
» Read more about: Story Type: News Story

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.