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
-
R4 / 1.169 cc / 50 PS / 68 ft/lb (92 Nm) @ 3.000 / 0 - 62 mph (100 km/h): 19,3 s (click images for a larger view)
-
V12 / 5.576 cc / 385 PS / 406 ft/lb (550 Nm) @ 4.000 / 0 - 62 mph (100 km/h): 6,6 s / Vmax: 155 mph (250 km/h) (click images for a larger ...
-
Stream/download new track Time by Danish indie pop/ Sarah Records inspired one man project Athletes ...totally brilliant stuff! T...
-
We are delighted to report a new development. The ingenuity of the drivers of Aberdeen Cars never ceases to amaze! And delight! Here we see ...
-
V8 / 4.973 cc / 231 PS / Vmax: 146 mph (235 km/h) (click images for a larger view)
-
Stream new song 20th Century by Swedish duo This Vision . Nice and catchy electro pop and...well that's pretty much it... 20th Cen...
-
After another year of 'fine tuning' Team Isetta returned to Hillsborough on the 26th of August 2012 to participate in the Parade ...
-
... сегодня у меня из машины стащили мой планшет Intuos3 =( не поленились просканили сигналку, стащили акуратно без взлома( у меня настроени...
-
S6 / 3.670 cc / 90 PS / 160 ft/lb (215 Nm) @ 1.400 / Vmax: 56 mph (90 km/h) (click images for a larger view)
-
Reports of the death of 4x4s greatly exaggerated A bit before Christmas, The Times splashed their front page with the almost gleeful headl...
No comments:
Post a Comment