1 Kicks

The Curse and Blessings of Dynamic SQL(sommarskog.se)

submitted by paul_houlepaul_houle(435) 3 years, 11 months ago

Nice article about Dynamic SQL for Microsoft's SQL Server. How to do it, why you should do it, and why you shouldn't.

1 comment |category: |Views: 14

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
paul_houlepaul_houle(435)
Comments:

posted by spootwospootwo(0) 3 years, 11 months ago 0

Highly opinionated. Dissapointed by the extreme bias against dynamic sql. Certainly it has some flaws, but this recommends avoiding them based on facts like this one:
"Forced parameterisation is, in my opinion, mainly a setting to cover up for poorly designed third-party application that uses unparameterised dynamic SQL."
His solution is to never use this feature of .NET. It's attitudes like this that hold us all back.
There are good gems of knowledge in this article, and the author certainly understands hand writing SQL, but the industry changes and the author needs to get with it or step off the soapbox.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?