Architecture
This post is in response to Frans Bouma's post, where he explains why Stored Procedures are bad. I'm not going to go over the differences of why to use Stored Procedures or why to use In-Line SQL, you can find many opinions on the topic by doing a simple search. I'm just going to reply to his post with my opinions.
One of the reasons why Frans likes to use Ad-Hoc (In-Line) SQL is because with SPs you have to write one SP for everything you do, which can become very annoying to...
Well, well, well, where do I start? I'm recreating this stored procedure for a client and I'm listing all columns I need from a table. What do I see? Something I thought I would never see in my life. The table contained a list of about 14 flags that specified something to be on or off. To be more specific, the columns looked like this: flag1_on, flag1_off, flag2_on, flag2_off and on and on it goes with a total of 7 flags * 2 (1 for off and other for on). I look at the data and I see that when...
Well, I just finished my N-Tier presentation and I can say it was the best presentation of all the 3 presentations I presented so far. The content was good, exciting, and cutting edge; and the crowd was the best I had. They laughed, and participated a lot. It was a very interactive session. It makes me really happy because a lot of the participants told me I did great job. As promised, below is the code and the presentation. Happy Programming!