I have always been a fan of dynamic SQL over stored procedures, simply because I felt that I have greater control over what SQL statements I would like to generate in code. And over the years, the gap between the benefits of dynamic SQL vs. stored procedures has also narrowed down.
Note: Now when I say dynamic SQL, I mean the one that uses named parameters ;)
But my current project has made me realized an important benefit of using stored procedures and that is ... when trying to upgrade from a very old SQL Server to a new version, it is difficult to identify which embedded SQL statement will break and it is even more difficult if the SQL statements are built using string concatenation and embedded in legacy VB6 code with no unit test.
Now, the SQL Upgrade Advisor tool will not be able read and 'advise' on these embedded SQL. So, in such scenario, I think using stored procedures would have been much better.
Home » SQL Server » Stored.Procedures
Popular Post
-
Have been hooked on Zuma lately (an online game provided by MSN). Never imagined that such a simple game can be so addictive. Previously, I...
-
The task of delivering software solutions on-time and on-demand has become a great challenge for many project teams nowadays with businesses...
-
"Too many cooks spoil the broth" As the famous saying goes but will too many developers spoil the code ? It actually depends on ...
-
Have you ever been handled over an abandoned system where you have no idea of it and asked to maintain or complete it? Lately, there were s...
-
Have you ever wished to be able to work from home? You know like, sitting on that nice comfy chair (or slumber on the bed), listening to the...
-
Just returned from an adhoc night-out with Cherine (Buttercup). She has been craving for a Pocket PC for the past weeks and when I called he...
-
Just came back from watching The Village. Not sure on how to comment about the movie. The feeling I had is like you went into the cinema and...
-
Today, I tried to explain the concept of Application Layering and Scale-out to a bunch of programmers. *It is always a challenge for archi...
-
"What you cannot measure, you cannot manage" - Peter F. Drucker Had a solid day in a Metrics Workshop and the above is just one...
-
I managed to get a colleague to give an unofficial preview on the upcoming O2 product line-ups today. Fans of O2 will definitely appreciate ...
No comments:
Post a Comment