The Curse and Blessings of Dynamic SQL

Here’s a topic I wanted to post on for some while. I’ve worked with many developers in my career and the topic of dynamic SQL has been a recurring theme. Should you use it? Isn’t there security / speed issues if you use it? How do you use it well? As with many topics it depends what your application for it is. Today I stumbled on an article that covers the topic very well. If you are interested in getting more info be sure to let me know. Query design is something I’ve noticed many developers could use some improvement on.

http://www.sommarskog.se/dynamic_sql.html

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: