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.
Popular Post
-
V12 / 5.999 cc / 725 PS / 490 ft/lb (665 Nm) @ 6.500 / 0 - 62 mph (100 km/h): 3,3 s / Vmax: 208+ mph (335+ km/h) (click images for a large...
-
In Congressional testimony last week, Alan Mullaly, head of Ford, committed the company to developing plug-in cars. Next month at the North...
-
The world is a wonderful, jacked-up place. I'd like to share what I see with you. This may be direct. This may be a life lesson learned ...
-
Regular readers will remember that last month we reported with fury and disbelief the upswing in recorded users of pedal cycles in Aberdeen...
-
I love stories that can't possibly be true but they ARE! And I love sharing those stories with friends and family. And I'd like to s...
-
The debate over plans for a drastic hike in car tax is starting to get interesting, amid increasing fears within government that the revised... -
V12 / 5.967 cc / 654 PS / 572 ft/lb (775 Nm) @ 4.200 / supercharger (click images for a larger view)
-
Cash For Clunkers Art Cars During the recent government "cash for clunkers" program this country witnessed an art car renaissance ... -
Costco, the big box retailer, has for over a decade been the business with more electric vehicle charge stations in more places around Calif... -
Once again, a conference on plug-in cars. Coming on the heels of the Google/Brookings event in Washington, D.C., Plug-in 2008 in San Jose, ...
No comments:
Post a Comment