Skip to main content
Database Administrators

Return to Question

added 9 characters in body; edited tags; edited title
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

Why would you want to avoid Dynamicdynamic SQL in stored procedureprocedures?

I have heard oneit said you do not want to use Dynamic SQL. Can you give me some concrete example or real-life exampleexamples? 

Personally, I code using it a few times in my database. I think it is OK because it'sof its flexibility. 

My guess is about SQL Injectioninjection or Performanceperformance. Anything else?

Why you want to avoid Dynamic SQL in stored procedure?

I have heard one said you do not want to use Dynamic SQL. Can you give some concrete example or real-life example? Personally, I code it a few times in my database. I think it is OK because it's flexibility. My guess is about SQL Injection or Performance. Anything else?

Why would you want to avoid dynamic SQL in stored procedures?

I have heard it said you do not want to use Dynamic SQL. Can you give me some concrete or real-life examples? 

Personally, I code using it a few times in my database. I think it is OK because of its flexibility. 

My guess is about SQL injection or performance. Anything else?

Tweeted twitter.com/#!/StackDBAs/status/238516112474660865
Source Link
Richard Sayakanit
Richard Sayakanit
  • 927
  • 2
  • 8
  • 12

Why you want to avoid Dynamic SQL in stored procedure?

I have heard one said you do not want to use Dynamic SQL. Can you give some concrete example or real-life example? Personally, I code it a few times in my database. I think it is OK because it's flexibility. My guess is about SQL Injection or Performance. Anything else?